--平均成绩和名次
SELECT 1+(SELECT COUNT( distinct 平均成绩)
FROM (SELECT Sid,AVG(score) AS 平均成绩
FROM SC
GROUP BY Sid
) AS T1
WHERE 平均成绩 > T2.平均成绩) as 名次,
Sid as 学生学号,平均成绩
FROM (SELECT Sid,AVG(score) 平均成绩
FROM SC
GROUP BY Sid
) AS T2
ORDER BY 平均成绩 desc;
博客园 收藏贴