|Subject||Re: [firebird-support] Get ID of record with minsort|
At 07:18 p.m. 25/06/2015, Josef.Gschwendtner@... [firebird-support] wrote:
>Hi,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?
>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?