题解 | #查找GPA最高值#
查找GPA最高值
https://www.nowcoder.com/practice/4e22fc5dbd16414fb2c7683557a84a4f
法一:
select gpa
from user_profile
where university = "复旦大学"
order by gpa desc
limit 1
法二:
select max(gpa)
from user_profile
where university = "复旦大学"
查找GPA最高值
https://www.nowcoder.com/practice/4e22fc5dbd16414fb2c7683557a84a4f
法一:
select gpa
from user_profile
where university = "复旦大学"
order by gpa desc
limit 1
法二:
select max(gpa)
from user_profile
where university = "复旦大学"
相关推荐