Equivalent of SQL "TOP X" in Oracle
A friend asked me a good question, so thought I'd share it and the answer for whomever it may help in the future.
Q: What is the equivalent of the SQL statement "SELECT TOP 10 * FROM myTable" in Oracle?
A: SELECT * FROM myTable WHERE ROWNUM < 11
Q: What is the equivalent of the SQL statement "SELECT TOP 10 * FROM myTable" in Oracle?
A: SELECT * FROM myTable WHERE ROWNUM < 11
Subscription Options
You are not logged in, so your subscription status for this entry is unknown. You can login or register here.
Re: Equivalent of SQL "TOP X" in Oracle
thank you
Posted by Azzedo on July 1, 2009 at 4:39 PM