题解 | #每个供应商成本最低的产品#
每个供应商成本最低的产品
http://www.nowcoder.com/practice/f0679d06b50049499691e12a435de8d8
方法:min()函数+group by分组的使用
select
vend_id,
min(prod_price) as cheapest_item
from
Products
group by
vend_id
order by
cheapest_item asc