select the first n rows of a table

[kathalena]

which function lets me select the first n rows of a table (oracle, sqlplus)? and which one selects the 2nd row (for example)?

i didn't find any function for that query...

thanks, kathalena

 

[vikramkalsi]

e.g.
To select first 4 rows from STUDENTS table.
SQL> select id from students where rownum < 5;
ID
----------
10000
10001
10002
10003

To select 2nd row from the same query
SQL>(select id from stds where rownum < 3 )
minus
(select id from stds where rownum < 2 );
ID
----------
10001

Hope this helps.

-Vikram

 

[kathalena]

THANKS a lot!! it works!

kathalena

 

[kathalena]

thanks a lot, it works!

kathalena