题解 | #对顾客ID和日期排序#
对顾客ID和日期排序
https://www.nowcoder.com/practice/fa4eb4880d124a4ead7a9b025fe75b70
此题有个坑,要求先对顾客ID进行升序排序,再对日期进行降序排序
select cust_id, order_num from Orders order by cust_id asc, order_date desc;
对顾客ID和日期排序
https://www.nowcoder.com/practice/fa4eb4880d124a4ead7a9b025fe75b70
此题有个坑,要求先对顾客ID进行升序排序,再对日期进行降序排序
select cust_id, order_num from Orders order by cust_id asc, order_date desc;
相关推荐