题解 | 商品价格排名

商品价格排名

https://www.nowcoder.com/practice/119f5b8cfe5b45779a3e1b3f4d83b341

with
    t as (
        select
            product_id,
            product_name,
            type,
            price,
            rank() over (
                Partition by
                    type
                order by
                    price DESC
            ) as rk
        from
            product_info
        group by
            type,
            product_id
    )
select
    product_id,
    product_name,
    type,
    price
from
    t
where
    rk <= 2
order by
    price desc,
    product_name asc
limit
    3;

全部评论

相关推荐

评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客网在线编程
牛客网题解
牛客企业服务