Re: How to limit # of rows returned by SELECT

ell_at_access4.digex.net (Ell) wrote:

>Anton Dischner (dischner_at_med.uni-muenchen.de) wrote:
>: Hi Gordon,
>:
>: try select * from <your_table> where rownum < 11;
>:
>: for the first ten items.
>: Note that the rownum is calculated last, so any other where clauses with
>: rownum will probably not work.
 

>Or: set rowcount X
 

>which specifies that subsequent operations act on X rows.
 

>Use: set rowcount 0
 

>to set things back to normal.
 

>Elliott

What version of SQLPLUS is that? It doesn't work in 7.1.x.

--
Chuck Hamilton
chuckh_at_ix.netcom.com

Never share a foxhole with anyone braver than yourself!