合并分组并计数mysql

本文介绍了合并分组并计数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