题解 | 找出每个学校GPA最低的同学
找出每个学校GPA最低的同学
https://www.nowcoder.com/practice/90778f5ab7d64d35a40dc1095ff79065
select u.device_id as device_id,u.university as university, u.gpa as gpa from (select * ,row_number() over (partition by ub.university order by ub.gpa asc) as rn from user_profile ub ) u where u.rn = 1 order by u.university;
查看15道真题和解析