distinct 去重 查找最大值 1.通过聚合函数取最大值 select max(gpa) from user_profile where university = '复旦大学' 2.通过 order by desc 从大到小排序 ,然后通过 limit 取第一条 select gpa from user_profile where university = '复旦大学' order by gpa DESC limit 1