sql按照查询排名加上排名的名次字段 发表于 2018-04-25 更新于 2019-07-18 分类于 mysql 格式 12345SELECT (@rowNO := @rowNo+1) AS rowno FROM (SELECT * FROM (自己的表名)) a,(SELECT @rowNO :=0) b 例子:根据分数排名并且加上排名名次字段rowno 12345SELECT (@rank := @rank+1) AS rank,a.name,a.score FROM (SELECT s.name,s.score FROM student s order by s.score) a,(SELECT @rank :=0) b