title: How to insert a count column into a sql query
body: <p>I need the second column of the table retrieved from a query to have a count of the number of rows, so row one would have a 1, row 2 would have a 2 and so on.  I am not very proficient with sql so I am sorry if this is a simple task.  </p>
  
  <p>A basic example of what I am doing would be is:</p>
  
  <pre><code>SELECT [Name], [I_NEED_ROW_COUNT_HERE],[Age],[Gender]
  FROM [customer]
  </code></pre>
  
  <p>The row count must be the second column and will act as an ID for each row.  It must be the second row as the text file it is generating will be sent to the state and they require a specific format.</p>
  
  <p>Thanks for any help.</p>