How about:

select first 10 skip 0 * from tablename;

David

----- Original Message -----
From: "Carlos Ortiz Quiros" <carlosaortiz@...>
To: <firebird-support@yahoogroups.com>
Sent: Friday, June 03, 2005 4:50 AM
Subject: [firebird-support] Does anybody know???


> Does anybody know how to convert the Microsoft SQL
> Server SELECT TOP 10 * FROM TableName to Firebird,
> that is, how can I write a query in Firebird SQL to
> retrieve the first 10 records out 1000 records from a
> result set.
>
> Thanks
>
> Carlos Adolfo Ortiz Q
> carlosaortiz@...
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>