题解 | 找出每个学校GPA最低的同学
with rank_u as (
select device_id, university, gpa,
RANK() OVER(
PARTITION by university
order by gpa
) as gpa_rank
from user_profile
)
select device_id, university, gpa
from rank_u
where gpa_rank = 1;
查看19道真题和解析