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

