题解 | #每个供应商成本最低的产品#
每个供应商成本最低的产品
https://www.nowcoder.com/practice/f0679d06b50049499691e12a435de8d8
select vend_id ,min(prod_price) cheapest_item from Products group by vend_id order by min(prod_price)
运行顺序是先group by →order by→order by
select的运行在order by 之后,因此order by后面加的字段必须是group by有的,或者是函数;否则会报错