Subject Re: What is the equalant keyword for Rownum(oracle) in Firebird DB
Author kishore_sairaj
--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> 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"
>
> 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

Hi Martin,
Thanks for ur reply. Can u please tell me where can i get
information on how to use write and use Firebird Stored Procedures
with PHP.

Thanks in advance