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
查询结果
本文标题:mysql查询分数并且显示排名的sql
本文链接:https://www.haomeiwen.com/subject/obngtxtx.html
网友评论