题解 | 找出每个学校GPA最低的同学
with t1 as ( select device_id, university, gpa, row_number() over ( partition by university order by gpa asc ) as rk from user_profile ) select device_id, university, gpa from t1 where rk = 1 order by university
with t1 as ( select device_id, university, gpa, row_number() over ( partition by university order by gpa asc ) as rk from user_profile ) select device_id, university, gpa from t1 where rk = 1 order by university
相关推荐