成绩排名SQL语句

--平均成绩和名次
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;

 

博客园 收藏贴