题解 | 查询订单
查询订单
https://www.nowcoder.com/practice/5ae7f48dc94f4a76b0ade40b70caf308
with t1 as(select *,row_number() over(partition by customer_id order by order_date desc) as rn from orders) select a.order_id,b.customer_name,order_date from t1 a join customers b on a.customer_id=b.customer_id where a.rn=1
查看6道真题和解析
