Re: LIMITING ROWS IN SELECT-STATEMENT

To be precise:
where rownum < 50 ( or any other number. mind the use of the lesser than symbol)
Although not supported by Oracle it is also possible to use: "where rownum = 1" if you want to fetch only one row. But, like I said, this is NOT supported by Oracle so it may not be wise to use it.

Regards,

Patrick Sinke
Cap Gemini Ernst & Young, sector Financial Services

Dave Fowler <d.fowler_at_smmj.com> schreef in berichtnieuws JeDI6.64$Ur6.8300_at_newsread2.prod.itd.earthlink.net...
> Oracle uses the reserved word ROWNUM
>
> "Ergün Ugurlu" <Erguen.Ugurlu_at_mathema.de> wrote in message
> news:3AF2F395.FA8D9D22_at_mathema.de...
> > hi,
> > how can i limit the number of rows a select-statement retrieves?
> > in other databases it's handled like this:
> > select * from 'tablename' where ROWNO <= 50
> > to get 50 rows max.
> >
> > thanks for any help
> >
> >
> >
>
>
Received on Mon May 07 2001 - 09:27:22 CEST