Subject Re: [firebird-support] SELECT with LIMIT on FIREBIRD
Author Lester Caine
netsurfer_ro wrote:

> i am new to FireBird 1.5
>
> In MySql i could do somethnig like this:
> SELECT * FROM table LIMIT 5,10;

SELECT [FIRST n] [SKIP n]
So you don't need both every time

> Can i do SOMETHING LIKE THAT in FireBird?
> (If not, maybe it could be done using the record number.)
No such thing as a record number. SKIP will just take you to the record
at that count from the start of the table depending on ORDER BY and
other filter factors.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services