title: How to write "Order By" clause before "Where" clause
body: <p>I want to write an <code>ORDER BY</code> clause before my <code>WHERE</code> condition because I need to truncate my results to just 10, but I need to sort them in alphabetical order first.</p>
  
  <p>I know that you can't put <code>ORDER BY</code> before <code>WHERE</code> so how can I do it?</p>
  
  <p>I need to do something like the following:</p>
  
  <pre><code>SELECT *
  FROM myTable
  ORDER BY TOP10
  WHERE ROWNUM &lt;=10
  </code></pre>