题解 | #查找后多列排序#

查找后多列排序

https://www.nowcoder.com/practice/39f74706f8d94d37865a82ffb7ba67d3

select device_id, gpa, age
from user_profile
order by gpa, age asc

#SELECT device_id,gpa,age from user_profile order by gpa,age;默认以升序排列
#SELECT device_id,gpa,age from user_profile order by gpa asc,age asc;

全部评论

相关推荐

点赞 收藏 评论
分享
牛客网
牛客企业服务