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
@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 排名