Select First 1 Fields from Table.

Ricardo.


_____

De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] En nombre de Steve Miller
Enviado el: Jueves, 10 de Mayo de 2007 06:38 p.m.
Para: firebird-support@yahoogroups.com
Asunto: [firebird-support] TOP 1?



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?

Steve







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