题解 | #每个供应商成本最低的产品#
每个供应商成本最低的产品
https://www.nowcoder.com/practice/f0679d06b50049499691e12a435de8d8
# select distinct p.vend_id, min(p.prod_price) as cheapest_item # from Products as p # group by p.vend_id # order by cheapest_item; select p.vend_id, min(p.prod_price) as cheapest_item from Products as p group by p.vend_id order by cheapest_item;
第一种方法为啥报错
查看15道真题和解析