今天碰到这样一个问题:如下图
其实很简单,看下面
select * from
(
select *,ROW_NUMBER() over(partition by Course order by Score desc)pm from Person
)Temp
where Temp.pm=2
今天碰到这样一个问题:如下图
其实很简单,看下面
select * from
(
select *,ROW_NUMBER() over(partition by Course order by Score desc)pm from Person
)Temp
where Temp.pm=2