题解 | 每个顾客最近一次下单的订单信息
每个顾客最近一次下单的订单信息
https://www.nowcoder.com/practice/4762ea22b0eb42ceb4f0a972c56d24c4
select order_id,customer_name,order_date from
(
select order_id,customer_name,order_date,
rank()over(partition by o.customer_id order by order_date desc) rk
from orders o join customers c on o.customer_id = c.customer_id
) z
where z.rk = 1
，目前也是月底了，面了大大小小很多次了，都没什么结果
