2020年3月13日
总成绩排序并排名
摘要： SELECT (@y :=@y + 1) 排名, s_id, sc FROM ( SELECT s_id, SUM(s_score) AS sc FROM score GROUP BY s_id ORDER BY SUM(s_score) DESC ) a, (SELECT @y := 0) AS 阅读全文
posted @ 2020-03-13 21:05 Axs 阅读(219) 评论(0) 推荐(0)