Subject Re: [firebird-support] What is the equalant keyword for Rownum(oracle) in Firebird DB
Author Martijn Tonies

> 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
Upscene Productions
Database development questions? Check the forum!