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

[Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]]

>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 want all rows returned:

Select ID_column
From <Table> t1
Where not exists(select * from <Table> t2 where t1.Sort > t2.Sort)

Alternatively, you could use

With tmp(Sort) as
(select min(Sort) from <table>)
Select t.ID_Column
From tmp
Join <table> t on tmp.Sort = t.Sort

Set