题解 | 每个顾客购买的最新产品名称
每个顾客购买的最新产品名称
https://www.nowcoder.com/practice/6ff37adae90f490aafa313033a2dcff7
select customer_id,customer_name,latest_order
from (
select o.customer_id,customer_name,product_name latest_order,
rank()over(partition by customer_id order by order_date desc) rk
from orders o join customers c on o.customer_id = c.customer_id
join products p on o.product_id = p.product_id
) z
where z.rk = 1
投递小天才等公司10个岗位