>
> How about:
>
> select first 10 skip 0 * from tablename;
>
> David

you need an order by here otherwise you will get unreliable results
Alan

>
> ----- 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
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>
>
>
>
>