mysql 两列计数,Mysql匹配两列并获得计数

我怎么算？

+---------+-------------+

| 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