group by求和
时间: 2023-08-22 17:06:19 浏览: 52
你可以使用SQL语句中的GROUP BY关键字来进行分组和求和操作。在你提供的引用内容中,有一个示例SQL语句可以用于求和。这是一个示例SQL语句:
SELECT TeamName, SUM(PeopleNum) AS TotalsPeopleNum, SUM(CraneMoney) AS TotalsCraneMoney
FROM PRJ_BuildLogInfo
GROUP BY TeamName;
在这个SQL语句中,我们使用GROUP BY关键字将PRJ_BuildLogInfo表中的记录按照TeamName字段进行分组,并使用SUM函数对PeopleNum和CraneMoney字段进行求和。这样,你就可以获得按照TeamName分组后的PeopleNum和CraneMoney的总和。<em>1</em><em>2</em><em>3</em>
#### 引用[.reference_title]
- *1* [MySql分组查询(group by)并计算对应的字段之和及两个字段相乘之后的和](https://blog.csdn.net/JiangName/article/details/78808041)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT0_1"}} ] [.reference_item]
- *2* *3* [linq group by 求和实例](https://blog.csdn.net/tink_tl/article/details/81939277)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT0_1"}} ] [.reference_item]
[ .reference_list ]