Re: How to get the first four rows???

re. limiting rows returned in oracle: surely just

Connected to:
Oracle7 Server Release 7.1.5.2.3 - Production Release PL/SQL Release 2.1.5.2.0 - Production

SQL> select spriden_pidm from saturn.spriden   2 where rownum < 5
  3 /

SPRIDEN_PIDM

         184
         185
         186
         187

will do the trick. or have i missed something... :) Received on Fri Jun 14 1996 - 00:00:00 CEST