title: How to query data with sequence of duplicated rows
body: <p>I have the following table with data:</p>
  
  <pre><code>    ID  SAL         
  _______________
      1   1500        
      1   1500        
      1   2000        
      1   1500        
      2   2500        
      2   2500        
      3   1500    
  </code></pre>
  
  <p>I want to query the same data <strong>BUT</strong> with new column that gives me a sequence of each duplicated row (based on id and sal columns).</p>
  
  <p>My desired query results should be like this:</p>
  
  <pre><code>   ID  SAL      ROW_SEQ
  _______________________
      1   1500     1
      1   1500     2
      1   2000     1
      1   1500     3
      2   2500     1
      2   2500     2
      3   1500     1
  </code></pre>
  
  <p>Any one has any idea <strong>PLEASE!..</strong></p>