Re: SQLPlus, How do you limit number of rows?

SQL> select count(*) from people;

 COUNT(*)

     1414

SQL> select people_id,zip from people
  2 where rownum < 10;

PEOPLE_ID ZIP
--------- ----------

        1 80004
       79 98273
       44 80003
       71 76902
       83 80021
       84 80021
       85 80401
       86 80112
       87 80021

9 rows selected.

"Sharon Diskin" <diskins_at_seas.upenn.edu> wrote in message news:3A54C66C.FFEEA858_at_seas.upenn.edu...
> Hello,
>
> Could someone tell me how to limit the number of rows returned/displayed
> from a select statement in SQLPlus? I thought this could be
> accomplished using ROWNUM, but, this does not appear to be possible.
>
> Thanks,
> Sharon
>
Received on Fri Jan 05 2001 - 05:38:44 CET