题解 | #找出每个学校GPA最低的同学#

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最低的

1. 根据gpa排序：

SELECT *,
dense_rank() over(
  partition by university 
  order by gpa) AS rankn 
  FROM user_profile) AS a

再用select嵌套一下