题解 | 每个顾客最近一次下单的订单信息
每个顾客最近一次下单的订单信息
https://www.nowcoder.com/practice/4762ea22b0eb42ceb4f0a972c56d24c4
with temp as (
select
o.order_id,
o.customer_id,
order_date,
row_number() over(partition by o.customer_id order by o.order_date desc) as rnk
from orders o
)
select
tp.order_id,
c.customer_name,
tp.order_date
from temp tp
inner join customers c
on c.customer_id = tp.customer_id
where tp.rnk = 1
窗口函数就是好用
