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] Thu, 25 Jun 2015 00:19:18 -0700
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