mysql聚合函数分组查询
时间: 2023-08-27 20:20:33 浏览: 64
在MySQL中,聚合函数和分组查询经常一起使用。在使用聚合函数时,通常需要在查询中添加GROUP BY子句来指定按照哪个列进行分组。GROUP BY子句通常与聚合函数(如max()、min()、count()、sum()和avg())一起使用,以便在分组的基础上对每个组进行计算。如果一条SQL语句没有GROUP BY子句,那么整张表的数据将自成一组。执行顺序是:FROM ... JOIN ON -> (LEFT/RIGHT JOIN) -> WHERE -> GROUP BY -> HAVING -> SELECT -> DISTINCT -> ORDER BY -> LIMIT。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *2* [MySQL基础篇 | 聚合(分组)函数 、分组查询](https://blog.csdn.net/m0_61933976/article/details/126273949)[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 style="max-width: 50%"]
- *3* [MySQL的聚合函数和分组查询](https://blog.csdn.net/weixin_57331959/article/details/118096355)[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 style="max-width: 50%"]
[ .reference_list ]