题解 | 商品价格排名

with rkp as 
(
select
    product_id,
    product_name,
    type,
    price,
    rank() over(partition by type order by price desc) as rk
from product_info
),
rkrkp as
(
select 
    product_id,
    product_name,
    type,
    price,
    rank() over(order by price desc ) as rkrk
from rkp
where rk<=2
)

select
    product_id,
    product_name,
    type,
    price
from rkrkp
where rkrk<=3
order by price desc,product_name;

局中局，太适合分块逻辑了😁