题解 | #每个供应商成本最低的产品#
每个供应商成本最低的产品
http://www.nowcoder.com/practice/f0679d06b50049499691e12a435de8d8
select vend_id,min(prod_price) as cheapest_item
from Products group by vend_id having cheapest_item
order by cheapest_item;
每个供应商成本最低的产品
http://www.nowcoder.com/practice/f0679d06b50049499691e12a435de8d8
select vend_id,min(prod_price) as cheapest_item
from Products group by vend_id having cheapest_item
order by cheapest_item;
相关推荐