Helpful Information
 
 
Category: Firebird SQL Development
How to use first(n) and skip(n)?

when I run this query:
select first(10) id from table1 it runs ok but if I run this one:

select first(10) skip(5) id from table1 I get an error saying the connection was lost.

Anyone knows how to use first(n) and skip(n)?

I'm using Firebird 1.5 rc3

select first 10 skip 5 id from table
should work










privacy (GDPR)