mysql查询分数并且显示排名的sql
2017-05-10 本文已影响0人
山水风情
SELECT A.*,@rank :=@rank + 1 AS ranking FROM ( SELECT user_name, user_source FROM test ORDER BY source DESC ) A, (SELECT @rank := 0) B
查询结果
SELECT A.*,@rank :=@rank + 1 AS ranking FROM ( SELECT user_name, user_source FROM test ORDER BY source DESC ) A, (SELECT @rank := 0) B
查询结果