You have 2 ways: SELECT FIRST 1 MyColumns FROM MyTable
That's the old way. SELECT MyColumns FROM MyTable ROWS 1 That's the new way. Greetings. Walter. On Sat, Dec 21, 2013 at 4:24 PM, firebirddev firebirddev < firebird...@gmail.com> wrote: > > > 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. > > >