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