统计收益排名 SELECT * FROM ( // 计算排名 select user_id,@curr_cnt:=cnt as cnt , @rank:=IF(@prev_cnt!=@curr_cnt,@rank+1