常用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
select t.* , px = DENSE_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