At 07:18 p.m. 25/06/2015, josef.gschwendt...@quattro-soft.de [firebird-support] wrote:
>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? That's not enough information. Do you want all of the IDs with the lowest sort-number? Or just any single ID with the lowest sort-number? Or the highest (or lowest) ID with the lowest sort-number. You can get any of those. with one statement..so which one? Helen