title: Oracle: Display row number with 'order by' clause
body: <p>I wonder how could i print a row number for sql statement where is using order. 
  Currently i tried <code>ROWNUM</code> but as i understand it works only for unsorted result set.</p>
  
  <pre><code>SELECT rownum, a.lg_id, a.full_name, a.sort_order
    FROM activity_type_lang a
    where a.lg_id = 'en'
    order by a.full_name;
  </code></pre>
  
  <p>TIA</p>