Subject Re: [firebird-support] What is the equalant keyword for Rownum(oracle) in Firebird DB
Author Magnus Titho
kishore_sairaj wrote:

> How to use ROWNUM in Firebird.
> For Example if i want to execute following Query what modification I
>have to make.
> "Select * from emp where rownum>10 and rownum<20"

If rownum is a field in your table your query is correct :)
But I guess you want this:

select first 10 skip 10 * from emp