Doug Boude (rhymes with 'loud') Powered by BlogCFM http://www.dougboude.com/blog Equivalent of SQL "TOP X" in Oracle <font face="Comic Sans MS" size="2">A friend asked me a good question, so thought I'd share it and the answer for whomever it may help in the future.<br /><br />Q:&nbsp; What is the equivalent of the SQL statement &quot;<b>SELECT TOP 10 * FROM myTable</b>&quot; in Oracle?<br /><br />A:&nbsp; <b>SELECT * FROM myTable WHERE ROWNUM &lt; 11</b></font> http://www.dougboude.com/blog/1/2006/06/Equivalent-of-SQL-TOP-X-in-Oracle.cfm 2006-06-24T02:06:00-05:00 SQL, ORACLE,goog, code snippets