题解 | 商品价格排名

with
    rank_salary as (
        select
            product_id,
            product_name,
            type,
            price,
            rank() over (
                partition by
                    type
                order by
                    price desc
            ) as r
        from
            product_info
        group by
            type,product_id
    )
select
    product_id,
    product_name,
    type,
    price
from
    rank_salary
where
    r <= 2
order by
    price desc,
    product_name
limit 3