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

 

Hi,

 

simplest if i understand you corectly

 

SELECT 

T.FLD_ID, T.FLD_SORT, (SELECT FIRST 1 T2.FLD_ID FROM TEST T2 WHERE T2.FLD_ID=T.FLD_ID ORDER BY T2.FLD_SORT) 

FROM 

TEST T 

 

or maybe you want?

 

SELECT 

DISTINCT (SELECT FIRST 1 T2.FLD_ID FROM TEST T2 WHERE T2.FLD_ID=T.FLD_ID ORDER BY T2.FLD_SORT) 

FROM 

TEST T 

 

but you got only 1 ID record if sort column will be doubled

 

regards,

Karol Bieniaszewski