统计多个条目/统计数据
统计多个条目/统计数据
提问于 2012-10-21 06:44:35
我想将调查添加到网站。现在我想在咖啡上加点奶油。
包含示例数据的表：
mysql> select * from u001;
+----+----------+------------+-------+---------------------+
| id | drink | sex | age | date |
+----+----------+------------+-------+---------------------+
| 1 | Beer | m | 30-39 | 2012-10-17 23:17:52 |
| 2 | Milk | f | 10-19 | 2012-10-18 00:15:59 |
| 3 | Milk | f | 20-29 | 2012-10-18 23:33:07 |
| 4 | Tea | m | 30-39 | 2012-10-20 22:47:08 |
| 5 | Water | f | 20-29 | 2012-10-20 22:47:30 |
| 6 | Milk | m | 30-39 | 2012-10-20 22:51:22 |
+----+----------+------------+-------+---------------------+
6 rows in set (0.00 sec)我想要得到一个计算有多少女人/男人喜欢茶/啤酒/等等的结果。一个想要的结果如下：
+-------+-----+---------+
| drink | sex | counted |
+-------+-----+---------+
| Beer | m | 1 |
| Milk | f | 2 |
| Tea | m | 1 |
| Water | f | 1 |
| Milk | m | 1 |
+-------+-----+---------+提前谢谢。
回答 2
Stack Overflow用户
回答已采纳
发布于 2012-10-21 06:45:58
SELECT drink, sex, COUNT(id) counted
FROM u001
GROUP BY drink, sexSQLFiddle Demo
Stack Overflow用户
发布于 2012-10-21 06:46:38
select drink, sex, count(id) from u001 group by drink, sex页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/12993346
复制相关文章
相似问题
腾讯云开发者
