题解 | 找出每个学校GPA最低的同学
找出每个学校GPA最低的同学
https://www.nowcoder.com/practice/90778f5ab7d64d35a40dc1095ff79065
SELECT device_id, university, gpa
FROM (
SELECT
device_id,
university,
gpa,
ROW_NUMBER() OVER (
PARTITION BY university
ORDER BY gpa ASC
) AS rn
FROM user_profile
) t
WHERE rn = 1
ORDER BY university;
海康威视公司福利 1182人发布
投递BOSS直聘等公司10个岗位