Subject | Re: [firebird-support] Re: What is the equalant keyword for Rownum(oracle) in Firebird DB |
---|---|
Author | Uwe Grauer |
Post date | 2005-09-30T14:21:05Z |
kishore_sairaj wrote:
http://groups.yahoo.com/group/firebird-php
Uwe
>--- In firebird-support@yahoogroups.com, "Martijn Tonies"There is a mailing-list for firebird-php:
><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
>
>
>
http://groups.yahoo.com/group/firebird-php
Uwe