Re: Limitting rows with ROWNUM

Steve Jakob wrote:
>
> alvin_at_c-square.no.junk says...
> >
> >Some months back I asked about limiting the number of rows returned
> >in a query in Oracle SQL.
> >
> >The answer is to use the ROWNUM pseudo-column.
> >
> >Eg:
> >
> > select columnname
> > from tablename
> > where rownum <= MAXROWS
> >

 <snip>
> >Alvin Sylvain
> >alvin_at_c-square.com
>
> Use a view and select from it:
>
> eg.
> CREATE VIEW view_example
> AS SELECT *
> FROM tablename
> ORDER BY some_column;
>
> SELECT columnname
> FROM view_example
> WHERE ROWNUM <= MAXROWS;

Thanks to all who responded!!

I'm going to SAVE the answers this time!!

:-)   Received on Fri Jan 10 1997 - 00:00:00 CST