Thank you David an Alan, I just didn´t know the fact
that First was not present in IB6, worder if present
in further versions of IB it is present.

By the way, then anybody knows where to find the
FB1.5.2 SQL syntax documentation. What does the
skip-part-clause means.

--- "David@Bigpond" <dhcebe@...> wrote:

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

Carlos Adolfo Ortiz Q
carlosaortiz@...



__________________________________
Discover Yahoo!
Find restaurants, movies, travel and more fun for the weekend. Check it out!
http://discover.yahoo.com/weekend.html