Sep 25, 2007 #1 pnad Technical User Joined May 2, 2006 Messages 133 Location US 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
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
Sep 25, 2007 #2 dbtoo2001 MIS Joined Jun 18, 2001 Messages 415 Location US http://download.oracle.com/docs/cd/B10501_01/server.920/a96540/sql_elements6a.htm#33158 Upvote 0 Downvote
Sep 25, 2007 #3 Thargy Technical User Joined Nov 15, 2005 Messages 1,348 Location GB 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 Upvote 0 Downvote
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