题解 | 每个顾客最近一次下单的订单信息
每个顾客最近一次下单的订单信息
https://www.nowcoder.com/practice/4762ea22b0eb42ceb4f0a972c56d24c4
WITH order_last AS(
SELECT
order_id,customer_id,
order_date,
rank() over (partition by customer_id order by order_date DESC) AS rk
FROM orders
)
SELECT
a.order_id,
b.customer_name,
a.order_date
FROM order_last AS a
LEFT JOIN customers AS b
ON a.customer_id=b.customer_id
WHERE a.rk=1;
海康威视公司氛围 515人发布