mysql - 如何创建下一个查询以进行分组

Question

我有这些疑问:

SELECT COUNT(*) AS numofrows, disposition,region FROM total_disposition_report WHERE disposition='ANSWERED' GROUP BY region ;

SELECT COUNT(*) AS numofrows, disposition,region FROM total_disposition_report WHERE disposition='BUSY' GROUP BY region ;

SELECT COUNT(*) AS numofrows, disposition,region FROM total_disposition_report WHERE disposition='...' GROUP BY region ;

SELECT COUNT(*) AS numofrows, disposition,region FROM total_disposition_report WHERE disposition='...' GROUP BY region ;

top 是否有机会在一个查询中获得相同的效果？

Answer 1

只需将disposition添加到group by:

例如:

SELECT COUNT(*) AS numofrows, disposition,region FROM total_disposition_report GROUP BY region, disposition;