[firebird-support] Get ID of record with minsort

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

Re: [firebird-support] Get ID of record with minsort

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-Statemen

Re: [firebird-support] Get ID of record with minsort

    W dniu 2015-06-25 09:18:48 użytkownik josef.gschwendt...@quattro-soft.de [firebird-support] 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-

RE: [firebird-support] Get ID of record with minsort

>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? If you want one row returned: Select ID_column From Order by Sort_Column Rows 1 If you wan

RE: [firebird-support] Get ID of record with minsort

Hi Set, thank you very much. Row 1 is the solution... It would have been so easy. Sepp