Subject RE: [firebird-support] Return Only One Row?
Author Jerry Sands
Post date 2013-12-21T20:48:39Z

SELECT FIRST 1 FieldName FROM Table

 

You can change the 1 to any number if you want a different count

 

 

 

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of firebirddev firebirddev
Sent: Saturday, December 21, 2013 2:24 PM
To: firebird-support@yahoogroups.com
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.