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
  • ... josef.gschwendt...@quattro-soft.de [firebird-support]
    • ... Helen Borrie hele...@iinet.net.au [firebird-support]
    • ... Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
      • ... josef.gschwendt...@quattro-soft.de [firebird-support]
    • ... liviuslivius liviusliv...@poczta.onet.pl [firebird-support]

Reply via email to