题解 | 查找GPA最高值

select gpa
from (
    select gpa, rank()over(partition by university order by gpa desc) rk
    from user_profile
    where university='复旦大学'
) newuser1
where newuser1.rk = 1

新手，没想到窗口函数之外的办法