题解 | 每个顾客购买的最新产品名称
每个顾客购买的最新产品名称
https://www.nowcoder.com/practice/6ff37adae90f490aafa313033a2dcff7
#三表连接
with rnk as (
select c.customer_id,c.customer_name,p.product_name,o.order_date,row_number() over (partition by o.customer_id order by order_date DESC) as rk
from orders as o
left join customers as c
on o.customer_id = c.customer_id
left join products as p
on o.product_id = p.product_id
)
select customer_id,customer_name,product_name as latest_order
from rnk
where rk=1
查看13道真题和解析