本文介绍两种使用SQL进行学生分数排名的方法。第一种方法利用子查询和DISTINCT关键字计算每个学生的分数排名；第二种方法则采用RANK()窗口函数实现相同目标。这两种方法均可实现在Table_3表中按分数高低对学生进行排名。
1------
SELECT *,(SELECT COUNT(DISTINCT Stu_Score) FROM Table_3 WHERE Stu_Score >= a.Stu_Score) as place
FROM Table_3 a
ORDER BY place
2----
select Stu_score,排名=rank() over (order by Stu_Score desc) from Table_3
SELECT *,(SELECT COUNT(DISTINCT Stu_Score) FROM Table_3 WHERE Stu_Score >= a.Stu_Score) as place
FROM Table_3 a
ORDER BY place
2----
select Stu_score,排名=rank() over (order by Stu_Score desc) from Table_3
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
