Jeffery17369
Jeffery17369
题解
题解 | #查找GPA最高值#
全部文章
题解
归档
标签
去牛客网
登录
/
注册
题解 | #查找GPA最高值#
392 浏览
0 回复
2022-04-20
Jeffery17369
+关注
查找GPA最高值
http://www.nowcoder.com/practice/4e22fc5dbd16414fb2c7683557a84a4f
select round(max(gpa),1) from user_profile where university = "复旦大学"
select round(gpa,1)
from user_profile
where university = "复旦大学"
order by gpa DESC
limit 1
Mysql
举报
收藏
赞 8
评论加载中...