mysql5.7 ORDER BY clause is not in GROUP BY clause and contains nonaggregated column

好郁闷，这句sql看着很正常，可是他就是报错，百度查资料基本都是修mysql的配置文件

SELECT item_id 
from tb_order_item as aa,tb_order as bb 
WHERE aa.order_id = bb.order_id 
GROUP BY aa.item_id 
ORDER BY bb.create_time desc 

解决方法

SELECT item_id 
from tb_order_item as aa,tb_order as bb 
WHERE aa.order_id = bb.order_id 
GROUP BY aa.item_id 
ORDER BY MAX(bb.create_time) desc 

关注

如果有问题，请在下方评论，或者加群讨论 200909980

关注下方微信公众号，可以及时获取到各种技术的干货哦，如果你有想推荐的帖子，也可以联系我们的。

码农笔录二维码