title: How to add a coulmn with seqeunce number
body: <p>I am trying to add a column to a query that will put a line number for each line with in a transaction.  </p>
  
  <pre><code>STORE CODE  TRANS NUMBER    LINE NUMBER
  12            1234                    1
  12            1234                    2
  12            1234                    3
  12            2345                    1
  12            2345                    2
  </code></pre>
  
  <p>This is my query any idea how to do this?</p>
  
  <pre><code>select sal_snum as "Store Code",sal_trn as "Transaction Number",
  sal_trm as "Register",sal_dt as "TrasactionDate",sal_tm as "TranactionTime",
  sum(sal_tax) as "TotalTaxAmount","" as "CustomerCode",
  "" As "CustomerCardType","" as "CustomerCardNumber",
  "" as "TotalPointsOnTransaction","" as "Note1","" as "Note2",
  sal_emp as "Staff 1 Code", "" as "Staff 2 Code","" as "Global Tax Code",
  "" as "Shipping Address Line 1","" as "Shipping Address Line 2",
  "" as "Shipping Contatc Name","" as "Shipping Contact Phone",
  "" as "Shipping Note","" as "Shipping Latitude",
  "" as "Shippong Longitude","" as "Layaway/Order Number","" as "Layaway Status"
  from sales
  group by sal_snum,sal_trn,sal_trm ,sal_dt ,sal_tm,sal_emp
  </code></pre>