题解 | #获得积分最多的人(二)#
获得积分最多的人(二)
https://www.nowcoder.com/practice/b6248d075d2d4213948b2e768080dc92
select u.id,u.name,t2.tt
from user u
join (
select *,dense_rank()over(order by tt desc) rk
from(
SELECT *
,sum(grade_num)over(partition by user_id) as tt
from grade_info
)t1
)t2
ON t2.user_id=u.id
WHERE t2.rk=1
group by u.id,u.name,t2.tt