Re: How to limit # of rows returned by SELECT

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 Received on Fri Feb 09 1996 - 00:00:00 CET