题解 | #找出每个学校GPA最低的同学#
找出每个学校GPA最低的同学
https://www.nowcoder.com/practice/90778f5ab7d64d35a40dc1095ff79065
SELECT device_id, university, gpa FROM ( SELECT *, dense_rank() over( partition by university order by gpa) AS rankn FROM user_profile ) AS a WHERE a.rankn = 1;
筛选gpa最低的：先根据gpa排序，再筛出gpq最低的
- 根据gpa排序：
SELECT *, dense_rank() over( partition by university order by gpa) AS rankn FROM user_profile) AS a
再用select嵌套一下
深信服公司福利 409人发布