sql where多个字段筛选

SELECT device_id,university,gpa FROM user_profile WHERE (university,gpa) 
IN (SELECT university,MIN(gpa) FROM user_profile GROUP BY university) ORDER BY university

# 使用窗口函数 ROW OVER() (PARITITION BY "按那个字段"  ORDER BY "对什么排序" )
SELECT device_id,university,gpa FROM (SELECT device_id,university,gpa,(RANK() over (PARTITION BY university ORDER BY gpa )) as m  FROM user_profile) AS A   WHERE  A.m=1