题解 | 每个顾客最近一次下单的订单信息
每个顾客最近一次下单的订单信息
https://www.nowcoder.com/practice/4762ea22b0eb42ceb4f0a972c56d24c4
select order_id, customer_name, order_date from ( select order_id, customer_id, order_date, row_number() over(partition by customer_id order by order_date desc) as rn from orders ) t1 left join customers t2 on t1.customer_id = t2.customer_id where t1.rn = 1 ;
查看15道真题和解析