题解 | 商品价格排名
select product_id, product_name, type, price from (select product_id, product_name, type, price, rank() over(partition by type order by price desc) as ranking from product_info) as t where ranking<3 order by price desc , product_name limit 3
纳芯微电子工作强度 4人发布
查看20道真题和解析
投递TCL等公司10个岗位 >