title: How to generate auto increment field in select query
body: <p>For example I have a table with 2 columns, <code>first_name</code> and <code>last_name</code> with these values</p>
  
  <pre><code>Ali           Khani
  Elizabette    Amini
  Britney       Spears
  ,...
  </code></pre>
  
  <p>I want to write a <code>select</code> query that generate a table like this:</p>
  
  <pre><code>1     Ali           Khani
  2     Elizabette    Amini
  3     Britney       Spears
  ,...
  </code></pre>
  
  <p>Thanks for your help.</p>