select
max(gpa ) AS gpa
from user_profile
WHERE
university='复旦大学'
另一种写法是select gpa from user_profile where university='复旦大学' order by gpa desc limit 1
select
max(gpa ) AS gpa
from user_profile
WHERE
university='复旦大学'
另一种写法是select gpa from user_profile where university='复旦大学' order by gpa desc limit 1