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