Subject AW: [firebird-support] select first and skip
Author Olaf Kluge
Hello Martijn,

>You could use a client side sorting method, eg via a TClientDataset.

>Alternatively, use a selectable stored procedure that returns the set of
>records and sort ASC when selecting from the stored procedure.

>Or use a Derived Table:

>select *
>from (select first 5 skip 10 ... order by id desc)
>order by id asc

>With regards,

>Martijn Tonies
>Upscene Productions
> <>

Many Thanks

[Non-text portions of this message have been removed]