题解 | #每个供应商成本最低的产品#
每个供应商成本最低的产品
https://www.nowcoder.com/practice/f0679d06b50049499691e12a435de8d8
select vend_id,min(prod_price) as cheapest_item from Products group by vend_id order by cheapest_item
知识点:
1、与上题没有区别
2、count(),换成min()
每个供应商成本最低的产品
https://www.nowcoder.com/practice/f0679d06b50049499691e12a435de8d8
select vend_id,min(prod_price) as cheapest_item from Products group by vend_id order by cheapest_item
知识点:
1、与上题没有区别
2、count(),换成min()
相关推荐