题解 | #对顾客ID和日期排序#
对顾客ID和日期排序
https://www.nowcoder.com/practice/fa4eb4880d124a4ead7a9b025fe75b70
SELECT cust_id, order_num FROM Orders ORDER BY cust_id ASC, order_date DESC;
注意是 order_date 排序,不是 order_num !!!
对顾客ID和日期排序
https://www.nowcoder.com/practice/fa4eb4880d124a4ead7a9b025fe75b70
SELECT cust_id, order_num FROM Orders ORDER BY cust_id ASC, order_date DESC;
注意是 order_date 排序,不是 order_num !!!
相关推荐