一个表的几个标准颜色的MySQL计数
一个表的几个标准颜色的MySQL计数
提问于 2013-09-18 15:47:33
我有一个数据事务表
Table Data (Month,Year,Type,Color)
+-------+------+-----------------------+---------------+
| Month | Year | type | Color |
+-------+------+-----------------------+---------------+
| 1 | 2013 | MATIC | BLACK |
| 1 | 2013 | MATIC | BLACK |
| 2 | 2013 | MATIC | BLACK |
| 2 | 2013 | MATIC | RED |
| 3 | 2013 | MATIC | WHITE |
| 3 | 2013 | MATIC | WHITE |
| 4 | 2013 | MATIC | WHITE |
| 4 | 2013 | MATIC | WHITE |
| 1 | 2013 | SPORT | RED |
| 1 | 2013 | SPORT | YELLOW |
| 2 | 2013 | SPORT | YELLOW |
| 2 | 2013 | SPORT | BLACK |
| 3 | 2013 | SPORT | BLACK |
+-------+------+-----------------------+---------------+我要按类型、颜色、年份、月份来计算数字，所以结果如下
+-------+------+-----------------------+---------------+--------+
| Month | Year | type | Color | Number |
+-------+------+-----------------------+---------------+--------+
| 1 | 2013 | MATIC | BLACK | 2 |
| 2 | 2013 | MATIC | BLACK | 1 |
| 2 | 2013 | MATIC | RED | 1 |
| 3 | 2013 | MATIC | WHITE | 2 |
| 4 | 2013 | MATIC | WHITE | 2 |
| 1 | 2013 | SPORT | RED | 1 |
| 1 | 2013 | SPORT | YELLOW | 1 |
| 2 | 2013 | SPORT | YELLOW | 1 |
| 2 | 2013 | SPORT | BLACK | 1 |
| 3 | 2013 | SPORT | BLACK | 1 |
+-------+------+-----------------------+---------------+--------+它的组按月份、年份、类型、颜色，有什么查询得到的号码？
回答 1
Stack Overflow用户
回答已采纳
发布于 2013-09-18 15:49:47
SELECT *, COUNT(*)
FROM table_name
GROUP BY month, year, type, color; -- TA DA!页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/18876801
复制相关文章
相似问题
腾讯云开发者
