mysql sum()函数的使用_mysql sum()-sum() input does not contain symbols f

作者：Cpp五条 | 2024-04-30 17:50:25

踩

mysql sum()-sum() input does not contain symbols from correlation

对所有数据进行查询，并对其中的department字段值相同的值进行累加查询。

SELECT `department` , sum( `item_real` ) , sum( `item_budget` ) , sum( `tuisuan` ) FROM `budget_all` GROUP BY `department`

仅仅对department=dd，dt进行求和：

select department,sum(item_real),sum(item_budget),sum(tuisuan) from budget_all where department='dt' or department='dd' group by department

求和原型：

select department,sum(item_real),sum(item_budget),sum(tuisuan) from tb group by department

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/Cpp五条/article/detail/514498