Subject | Re: [firebird-support] SELECT with LIMIT on FIREBIRD |
---|---|
Author | Lester Caine |
Post date | 2004-11-12T07:43:38Z |
netsurfer_ro wrote:
So you don't need both every time
at that count from the start of the table depending on ORDER BY and
other filter factors.
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
> i am new to FireBird 1.5SELECT [FIRST n] [SKIP n]
>
> In MySql i could do somethnig like this:
> SELECT * FROM table LIMIT 5,10;
So you don't need both every time
> Can i do SOMETHING LIKE THAT in FireBird?No such thing as a record number. SKIP will just take you to the record
> (If not, maybe it could be done using the record number.)
at that count from the start of the table depending on ORDER BY and
other filter factors.
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services