[firebird-support] Return Only One Row?

[firebirddev firebirddev]

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.