说明: 常用sql语句和函数 select t.* , px = rank() over(order by [平均成绩] desc) from ( select m.Sno [学生编号] , m.Sname [学生姓名] , isnull(cast(avg(score) as decimal(18,2)),0) [平均成绩] from Student m left join SC n on m.Sno = n.Sno group by m.Sno , m.Sname ) t order by px s <javagetvoid> 上传 | 大小:36kb