题解 | #找出每个学校GPA最低的同学#
找出每个学校GPA最低的同学
https://www.nowcoder.com/practice/90778f5ab7d64d35a40dc1095ff79065
select
tb.device_id,
tb.university,
tb.gpa
from (
select
ta.device_id,
ta.university,
ta.gpa,
row_number() over (partition by university order by gpa) as rk
from
user_profile as ta
) as tb
where
tb.rk = 1
order by
tb.university
;
OPPO公司福利 1071人发布