题解 | #每个供应商成本最低的产品#
每个供应商成本最低的产品
https://www.nowcoder.com/practice/f0679d06b50049499691e12a435de8d8
select vend_id,prod_price as cheapest_item from(select *,rank()over(partition by vend_id order by prod_price asc) rk from Products) t where t.rk =1 order by cheapest_item asc;
查看8道真题和解析