select device_id,university,gpa from ( select device_id,university,gpa,rank() over (partition by university order by gpa) r from user_profile ) rk where r=1 order by university
相关推荐