题解 | #查找GPA最高值#
查找GPA最高值
https://www.nowcoder.com/practice/4e22fc5dbd16414fb2c7683557a84a4f
select gpa from user_profile where university = '复旦大学' order by gpa desc -- order by gpa desc,从大到小排序 limit 0,1 ;-- 取第一个 select max(gpa) as gpa -- max() as 取表列最大值，表列名命名 from user_profile where university = '复旦大学';
查看1道真题和解析