kishore_sairaj wrote:

>Hi,
> 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


--
Magnus