题解 | #查找GPA最高值#

1. -- 方法一

select gpa from user_profile where university = '复旦大学' order by gpa DESC limit 0,1

1. -- 方法二

SELECT DISTINCT gpa from ( select gpa, dense_rank() over (order by gpa desc) rk from user_profile) T where rk = 1

1. -- 方法三

select distinct max(gpa) gpa from user_profile where university = '复旦大学'