aslında bir yolu daha vardı
bir union sorgu
SELECT DISTINCT [girisno],[1cihaz] as cihaz
FROM Table1
WHERE [1cihaz] > 0
UNION SELECT DISTINCT [girisno],[2Cihaz]
FROM [Table1]
WHERE [2cihaz] > 0
ORDER BY [cihaz];
UNION SELECT DISTINCT [girisno],[3Cihaz]
FROM [Table1]
WHERE [3cihaz] > 0
ORDER BY [cihaz];
UNION SELECT DISTINCT [girisno],[4Cihaz]
FROM [Table1]
WHERE [4cihaz] > 0
ORDER BY [cihaz];
UNION SELECT DISTINCT [girisno],[5Cihaz]
FROM [Table1]
WHERE [5cihaz] > 0
ORDER BY [cihaz];
UNION SELECT DISTINCT [girisno],[6Cihaz]
FROM [Table1]
WHERE [6cihaz] > 0
ORDER BY [cihaz];
UNION SELECT DISTINCT [girisno],[7Cihaz]
FROM [Table1]
WHERE [7cihaz] > 0
ORDER BY [cihaz];
UNION SELECT DISTINCT [girisno],[8Cihaz]
FROM [Table1]
WHERE [8cihaz] > 0
ORDER BY [cihaz];

diğer sorguda Dfirst ve Dlast ile en büyük ve en küçük alınabilir di