title: MSSQL Row_Number() over(order by) in MySql
body: <p>i need to make a group by clause with the following query:  </p>
  
  <pre><code>SELECT NAME, SUM(donationvalue) FROM tbl_pdm2k10_Donations
  GROUP BY NAME
  ORDER BY SUM(donationvalue) desc
  </code></pre>
  
  <p>but i want a column on the left returning me: 1, 2, 3, 4, 5, etc as as result.
  In MSSql i would do</p>
  
  <pre><code>  SELECT Row_Number() Over(order by SUM(donationvalue) desc), NAME, SUM(donationvalue)      
   FROM tbl_pdm2k10_Donations
      GROUP BY NAME
  </code></pre>
  
  <p>is this possible?</p>