mysql查找重复
标签：
mysql查找重复
??? ? ?? ??
SELECT ???, count(*) FROM ???? GROUP BY ???
mysql> SELECT t1, count(*) FROM test GROUP BY t1
??? ??? n? ??? ? ??
SELECT ???, count(*) as ??? FROM ???? GROUP BY ??? HAVING ???>n
mysql> SELECT t1, count(*) as num FROM test GROUP BY t1 HAVING num>1;
+------------+-----+
| t1 | num |
+------------+-----+
| tulip pink | 2 |
| ??? | 2 |
+------------+-----+
2 rows in set (0.01 sec)