title: How to find row number of a record?
body: <p>Consider example table below</p>
  
  <pre><code>ProductDetailNo    ProductDescription
        224                Apples
        225                Tomatoes
        226                Potatoes
  </code></pre>
  
  <p>How do I list the row number for a selected row like below ?</p>
  
  <pre><code>RowNo    ProductDetailNo          Product Description
    2         225                Tomatoes
  </code></pre>
  
  <p>Using row_number() in my query just returns 1 always for a single record no mater what the logical row is in the database.</p>
  
  <p>Thanks, Damien.</p>