MySql中的计数和分组行

Question

我使用Mysql数据库5.5.24-log版本。

在此表中，我无法对字段Premium_name的值​​进行计数和分组。

在输出中，我需要2作为最终值，因为在表中只有两个Premium_name:流体速度和GLOCKENSPIELMEMORIAL。

提前谢谢你。

SELECT
    COUNT(*), Premium_name
FROM
    `table_premium`
GROUP BY
    Premium_name;

+----------+----------------------+
| COUNT(*) | Premium_name         |
+----------+----------------------+
|        2 | GLOCKENSPIELMEMORIAL |
|        6 | HYDROSPEED           |
+----------+----------------------+
2 rows in set


+--------------+------------------+----------------------+--------------+
| Premium_area | Premium_sub_area | Premium_name         | Premium_code |
+--------------+------------------+----------------------+--------------+
| 51PD         | 51PDK1           | HYDROSPEED           |     48069794 |
| 51PD         | 51PDK1           | HYDROSPEED           |     48069795 |
| 51PD         | 51PDK1           | HYDROSPEED           |     49301672 |
| 51PD         | 51PDK1           | HYDROSPEED           |     52480075 |
| 51PD         | 51PDK1           | HYDROSPEED           |     52646404 |
| 51PD         | 51PDK1           | HYDROSPEED           |     91189540 |
| 51PD         | 51PDK2           | GLOCKENSPIELMEMORIAL |     45824206 |
| 51PD         | 51PDK2           | GLOCKENSPIELMEMORIAL |     48479834 |
+--------------+------------------+----------------------+--------------+

Answer 1

SELECT COUNT(DISTINCT Premium_name), Premium_name 
FROM
    `table_premium`

Answer 2

试试这个：

SELECT COUNT(1) AS PREMIUMS FROM
(SELECT
 DISTINCT Premium_name
 FROM
`table_premium`)CS

Answer 3

从Premium_name组中按Premium_name从table_premium组中选择COUNT(不同的Premium_name)