题解 | #找出每个学校GPA最低的同学#

select
    device_id,university,min_gpa
from
    (select 
        device_id,university,gpa,min(gpa) over(partition by university) as min_gpa
    from  
        user_profile) as up
where
    up.gpa = up.min_gpa

https://www.jianshu.com/p/0bc3de29aa9d