题解 | #查找后多列排序#
查找后多列排序
https://www.nowcoder.com/practice/39f74706f8d94d37865a82ffb7ba67d3
select device_id, gpa, age from user_profile order by gpa asc,age asc;
直接在order by的条件中加入,即可。 默认排序为asc
所以可以直接去掉两个asc
select device_id, gpa, age from user_profile order by gpa, age ;
查看2道真题和解析