题解 | #获得积分最多的人(一)#
获得积分最多的人(一)
https://www.nowcoder.com/practice/1bfe3870034e4efeb4b4aa6711316c3b
#非累加,普通加和 select t2.name, t2.B from (select * ,rank()over(order by t1.B desc) as ra1 from (select user_id ,sum(grade_num) as B from grade_info group by user_id) as t1 left join user on t1.user_id= user.id) as t2 where t2.ra1=1
查看11道真题和解析