On 5/11/07, Steve Miller <Steve_Miller@...> wrote:
> 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?

Firebird does support this functionality, the only thing you'd need to
change is the syntax:

SELECT FIRST 1 MyColumn FROM MyTable ORDER BY SomeOrd

Regards
Gareth Marshall


[Non-text portions of this message have been removed]