W dniu 2015-06-25 09:18:48 użytkownik [email protected] [firebird-support] <[email protected]> napisał: Hi, I have a table with one ID-Column and one Sort-Column. I need the ID from the record with the lowest sort-number. Sortnumbers are not unique (can be doubled). Can I do this with one SQL-Statement? Thank you for your help. Regards, Josef
Hi, simplest if i understand you corectly SELECT T.FLD_ID, T.FLD_SORT, (SELECT FIRST 1 T2.FLD_ID FROM TEST T2 WHERE T2.FLD_ID=T.FLD_ID ORDER BY T2.FLD_SORT) FROM TEST T or maybe you want? SELECT DISTINCT (SELECT FIRST 1 T2.FLD_ID FROM TEST T2 WHERE T2.FLD_ID=T.FLD_ID ORDER BY T2.FLD_SORT) FROM TEST T but you got only 1 ID record if sort column will be doubled regards, Karol Bieniaszewski
