MySQL 添加排名列

 SELECT
   @rownum:=@rownum+1 
   if( @rank=t1.score , @test:=@test  , @test:=@rownum) as RANK , t1.* ,
   @rank:=t1.score
 from 
(
SELECT  income_expend  As score FROM es_project_report 
ORDER BY score 

)t1  , (SELECT @test:=0, @rownum:=0) r 

@rownum 获取当前行数   

@rank   获取上一条数据的分数

RANK    排名