ROWNUM

[pnad]

Can I use anything in Oracle that is similar to the TOP function in MS SQL.

This is what I would like to do in Oracle:

Select * from <table_name>
where rownum > 1 and rownum <= 10

 

[dbtoo2001]

http://download.oracle.com/docs/cd/B10501_01/server.920/a96540/sql_elements6a.htm#33158

 

[Thargy]

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:127412348064

Note that the illustrious Mr Kyte shows which way is best with metrics to prove it.

Grinding away at things Oracular