MYsql 排名

SELECT @counter:=@counter+1 AS rank,t.*FROM (SELECT a.id,b.player_name,a.snatch_timesFROM player_attribute a,player bWHERE a.id = b.id AND IFNULL(a.snatch_times,0)>0ORDER BY a.snatch_times DESC) t,(SELECT @counter :=0) r;