题解 | #每个供应商成本最低的产品#
每个供应商成本最低的产品
https://www.nowcoder.com/practice/f0679d06b50049499691e12a435de8d8
select vend_id, #分组后开新的列由旧的列加上聚合函数就能实现 min(prod_price) cheapest_item from Products group by vend_id order by cheapest_item;
每个供应商成本最低的产品
https://www.nowcoder.com/practice/f0679d06b50049499691e12a435de8d8
select vend_id, #分组后开新的列由旧的列加上聚合函数就能实现 min(prod_price) cheapest_item from Products group by vend_id order by cheapest_item;
相关推荐