题解 | #计算总和#
计算总和
http://www.nowcoder.com/practice/d8a624021183454586da94d280cc8046
SELECT order_num, SUM(item_price * quantity) total_price FROM OrderItems GROUP BY order_num HAVING total_price >= 1000 ORDER BY order_num;
2022-03-05 19:27 华南农业大学 golang
关注
全部评论
JasonViogd
华中科技大学 数据分析师
请问一下，为何我将item_price * 移到sum函数外部就会报错运行不了，就像下面这个样子 SELECT order_num, item_price *SUM(quantity) total_price FROM OrderItems GROUP BY order_num HAVING total_price >= 1000 ORDER BY order_num; 报错如下 SQL_ERROR_INFO: "Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'OrderItems.item_price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by"
牛客839933533号
广东机电职业技术学院 运维工程师
小白有点想不懂，请教一下，为什么要用sum，不能直接item_price * quantity，然后group by bu不是会分组后把item_price * quantity汇总吗？
相关推荐
，养生
小浪_Coding：你问别人,本来就是有求于人,别人肯定没有义务免费回答你丫, 有点流量每天私信可能都十几,几十条的,大家都有工作和自己的事情, 付费也是正常的, 就像你请别人搭把手, 总得给人家买瓶水喝吧 
点赞 评论 收藏
分享
点赞 评论 收藏
分享