题解 | #查找GPA最高值#
查找GPA最高值
http://www.nowcoder.com/practice/4e22fc5dbd16414fb2c7683557a84a4f
1、表头重命名,筛选出最大值 select max(gpa) as gpa from user_profile where university='复旦大学'
2、select gpa from user_prfile where university='复旦大学' group by gpa desc limt 1