题解 | 查询订单
查询订单
https://www.nowcoder.com/practice/5ae7f48dc94f4a76b0ade40b70caf308
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 ) ranking from orders o left join customers c on o.customer_id = c.customer_id)rk where ranking = 1
