SELECT FIRST 1 FieldName FROM Table
You can change the 1 to any number if you want a different count From: [email protected] [mailto:[email protected]] On Behalf Of firebirddev firebirddev Sent: Saturday, December 21, 2013 2:24 PM To: [email protected] Subject: [firebird-support] Return Only One Row? Hello. I was wondering how do I limit the data set to only return a single row? So where a table would contain let us say 10 rows, I am only interested in the first row (I will order the data set prior to this). Thanks.
