题解 | #每个供应商成本最低的产品#
每个供应商成本最低的产品
https://www.nowcoder.com/practice/f0679d06b50049499691e12a435de8d8
select vend_id, prod_price as cheapest_item
from (
select vend_id, prod_price, ROW_NUMBER() OVER (partition by vend_id order by prod_price ) as col
from Products
) a
where a.col = 1
order by prod_price
投递美团等公司7个岗位 >
