Top 10 sql query list : <p>Good morning, I need assistance with generating a top 10 list. below is the created query however i'm unsure how to correctly implement the <em>ROWNUM</em> function.</p>

<pre><code>SELECT * FROM
( SELECT CON_NAME, HIGHEST_QUAL FROM temp2 ORDER BY HIGHEST_QUAL DESC )
  WHERE ROWNUM = 10;
</code></pre>

<p>As when the query is run no data is produced however when i omit the <em>ROWNUM</em> all the rows are produced showing the data is there. Also when the <em>ROWNUM</em> is set to 1 only one row is produced.</p>

<p>Thanks in advance!</p>
