Hi Set,
thank you very much.
Row 1 is the solution...
It would have been so easy.
Sepp
>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
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
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-