> > Can anyone please tell me how to use the First and Skip clauses
> > in Firebird?
> >
> > Select First(10) Skip (10) From MyTable; doesnt work.
>
> select what?
> try: select first(10) skip(10) * from mytable
> or select first(10) skip(10) nameofcol1, nameofcol2 from mytable

It's actually

select first 10 skip 10 * from mytable

, or

select first 10 skip 10 nameofcol1, nameofcol2 from mytable

--
Sean Leyne

Want to support Firebird development?
Become a member of the FirebirdSQL Foundation!
http://www.firebirdsql.org/foundation