在MySQL中的MSSQL Row_Number() over(order by)

Question

我需要在以下查询中使用group by子句：

SELECT NAME, SUM(donationvalue) FROM tbl_pdm2k10_Donations
GROUP BY NAME
ORDER BY SUM(donationvalue) desc

但我想在左边加一列，返回结果为1、2、3、4、5等。在MSSql中，我会这样做：

  SELECT Row_Number() Over(order by SUM(donationvalue) desc), NAME, SUM(donationvalue)      
 FROM tbl_pdm2k10_Donations
    GROUP BY NAME

这是可能的吗？

- André Alçada Padez

Answer 1

set @row:=0;
SELECT 
  @row:=@row+1 as row_numer,
  NAME, 
  SUM(donationvalue) as total 
FROM tbl_pdm2k10_Donations
GROUP BY NAME
ORDER BY total desc

- ajreal

Answer 2

是的（使用变量）

请参见http://www.xaprb.com/blog/2006/12/02/how-to-number-rows-in-mysql/

- Martin Smith