题解 | #每个供应商成本最低的产品#
每个供应商成本最低的产品
http://www.nowcoder.com/practice/f0679d06b50049499691e12a435de8d8
SELECT vend_id, MIN(prod_price) cheapest_item FROM Products GROUP BY vend_id ORDER BY cheapest_item;
每个供应商成本最低的产品
http://www.nowcoder.com/practice/f0679d06b50049499691e12a435de8d8
SELECT vend_id, MIN(prod_price) cheapest_item FROM Products GROUP BY vend_id ORDER BY cheapest_item;
相关推荐
elliot19:确实是这样,上次就纯聊天,问项目实习做啥,最后掏了一道非hot100的hard
查看6道真题和解析