34,838
社区成员




select id,name,date,score
from
(
select *,
ROW_NUMBER() over(partition by id
order by score desc) as rownum
from 学生表
)t
where rownum=1
select id,name,date,score
from
(
select *,
ROW_NUMBER() over(partition by id
order by score desc)
from 学生表
)t
where rn=1
select *
from
(
select *,rn=ROW_NUMBER() over(partition by 学号 order by 分数 desc) from 成绩表
)t
where rn=1