题解 | #找出每个学校GPA最低的同学#
找出每个学校GPA最低的同学
https://www.nowcoder.com/practice/90778f5ab7d64d35a40dc1095ff79065
select
b.device_id
,a.*
from
(
select
university
,min(gpa) as gpa
from user_profile
group by 1
) a
left join
(
select
*
,row_number()over(partition by university order by gpa) rk
from user_profile
)b
on a.university = b.university
and a.gpa = b.gpa
where rk = 1
order by 2
快手公司福利 935人发布