我怎么算?
+---------+-------------+
| col1 | col2 |
+---------+-------------+
| Joe | April |
| Fred | May |
| Sam | April |
| Joe | April |
| Mark | Jan |
| Joe | Dec |
+---------+-------------+
在MYSQL中如何计算只有在月份匹配时才匹配的名称?
IE
乔四月应该只有一个……
解决方法:
@Abdul’s answer只需要HUNT COUNT(*)> 1
查询shold现在看起来像这样
SELECT COUNT(*), col1 , col2 FROM test GROUP BY col1,col2 HAVING COUNT(*) > 1;
这是执行它:
mysql> create table test(col1 varchar(20),col2 varchar(20));
Query OK, 0 rows affected (0.33 sec)
mysql> INSERT INTO test VALUES('Joe','April'),('Fred','May'),
-> ('Sam','April'),('Joe','April'),('Mark','Jan'),('Joe','Dec');
Query OK, 6 rows affected (0.06 sec)
Records: 6 Duplicates: 0 Warnings: 0
mysql> SELECT COUNT(*), col1 , col2 FROM test GROUP BY col1,col2 HAVING COUNT(*) > 1;
+----------+------+-------+
| COUNT(*) | col1 | col2 |
+----------+------+-------+
| 2 | Joe | April |
+----------+------+-------+
1 row in set (0.24 sec)
mysql>
如果您不关心计数,请将其从SELECT子句中删除
mysql> SELECT col1 , col2 FROM test GROUP BY col1,col2 HAVING COUNT(*) > 1;
+------+-------+
| col1 | col2 |
+------+-------+
| Joe | April |
+------+-------+
1 row in set (0.00 sec)
mysql>
试试看 !!!
标签:mysql,count
来源: https://codeday.me/bug/20190806/1601521.html