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"

Firebird doesn't have a "rownum" facility.

But selecting a particular piece of a resultset if possible --
check the Firebird 1.5 release notes and look for "FIRST [n] [SKIP m]"

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com