合并分组并计数mysql [英] Combine group by and count mysql

问题描述

我需要使用分组依据查找表中的所有状态:

I need to find out all statuses in a table using group by:

SELECT status FROM table GROUP BY status

然后计算发现的结果

SELECT count(id) WHERE status = [STATUS]

像这样的表

+--------------------+
| ID | STATUS | NAME |
+--------------------+
|0001| BOUGHT | JOHN | 
----------------------
|0002| BOUGHT | JOHN | 
----------------------
|0003| CANCEL | JOHN | 
----------------------
|0004| BOUGHT | JOHN | 
----------------------
|0005| CANCEL | JOHN | 
---------------------
|0006| BOUGHT | JOHN | 
----------------------
|0007| BOUGHT | JOHN | 
----------------------
|0008| SAVE   | JOHN | 
----------------------
|0009| SAVE   | JOHN | 
----------------------
|0010| BOUGHT | JOHN | 
----------------------
|0011| SAVE   | JOHN | 
----------------------

将产生如下结果:

STATUS | COUNT
---------------
SAVE   | 3
BOUGHT | 6
CANCEL | 2

感谢您的帮助.

推荐答案

在以下查询中使用:

SELECT status, count(id) as CNT FROM table GROUP BY status

这篇关于合并分组并计数mysql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！