题解 | #每个供应商成本最低的产品#
每个供应商成本最低的产品
https://www.nowcoder.com/practice/f0679d06b50049499691e12a435de8d8
-- 使用窗口函数row_number() over() 得到每个以vend_id 分组得到得
select t.vend_id,
t.prod_price cheapest_item
from (
select vend_id,
prod_price ,
row_number() over(partition by vend_id order by prod_price) rN
from Products
group by vend_id,prod_price
) t
where rn = 1
order by cheapest_item ;
查看10道真题和解析
