Subject Re: [firebird-support] TOP 1?
Author Martijn Tonies
> >> I thought I read somewhere that the latest version of Firebird
> >> supports selecting the first record from a result set, such as this
> >> query in SQL Server:
> >>
> >> SELECT TOP 1 MyColumn FROM MyTable ORDER BY SomeOrd
> >>
> >> Is this true, or am I dreaming it? If it's still a dream, what do
> >> people do for a workaround?

As a workaround, people execute the statement and only fetch the first row.


Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
My thoughts:
Database development questions? Check the forum!