题解 | 每个顾客最近一次下单的订单信息
每个顾客最近一次下单的订单信息
https://www.nowcoder.com/practice/4762ea22b0eb42ceb4f0a972c56d24c4
SELECT
order_id,
customer_name,
order_date
FROM orders o JOIN customers c
ON o.customer_id = c.customer_id
WHERE order_date IN (
SELECT
MAX(order_date)
FROM orders
GROUP BY customer_id
)
ORDER BY customer_name
查看1道真题和解析