title: ROW_NUMBER and PARTITION query returning all rows ranked as 1
body: <p>I am having issues with a query, I want it to rank the result based on the time the last change was recorded.</p>
  
  <pre><code>SELECT
    ROW_NUMBER() OVER (PARTITION BY ph.pricingHistoryId ORDER BY ph.changeRecorded DESC),
    ph.*
  FROM
    PriceHistory ph
  </code></pre>
  
  <p>It returns all 1 for the ranking.</p>