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-Statement?

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] firebird-support@yahoogroups.com 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

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 Table Order by Sort_Column Rows 1 If you

[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

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