select gpa from ( select gpa, rank()over(partition by university order by gpa desc) rk from user_profile where university='复旦大学' ) newuser1 where newuser1.rk = 1 新手,没想到窗口函数之外的办法