title: Oracle - add counter to query
body: <p>I am looking to add in a simple counter to an SQL Query - i.e., if I run a query on individual surnames that returns 3 results I would like the results to display their row value from the query. E.g.:</p>
  
  <pre><code>Surnames   Counter
  Smith         1
  Murphy        2
  Brown         3
  </code></pre>
  
  <p>How can this be done?</p>