我想从MySQL数据库中取出重复的记录。
----------------------------
| id | column_a | column_b |
|----|----------|----------|
| 1 | a | b |
| 2 | a | c |
| 3 | a | d |
| 4 | a | b |
| 5 | b | e |
| 6 | c | a |
| 7 | c | d |
| 8 | e | a |
| 9 | e | a |
----------------------------我想拉出它,这样它就会显示每一行都是重复的。类似于:
------
| id |
|----|
| 1 |
| 4 |
| 8 |
| 9 |
------或
---------------------------------------
| duplicate_ids | column_a | column_b |
|---------------|----------|----------|
| 1,4 | a | b |
| 8,9 | e | a |
---------------------------------------对如何做到这一点有什么想法吗?
发布于 2012-08-07 16:17:52
select group_concat(id) as duplicate_ids,
columna,
columnb
from your_table
group by columna, columnb
having count(id) > 1发布于 2012-08-07 16:19:17
试试GROUP_CONCAT
SELECT GROUP_CONCAT(id), column_A, column_B
FROM mytable
GROUP BY columnA, columnB
HAVING COUNT(id) > 1发布于 2012-08-07 16:20:24
SELECT
GROUP_CONCAT(id) as ids,
column_a,
column_b
FROM table
GROUP BY column_a, column_b
HAVING COUNT(id) > 1https://stackoverflow.com/questions/11841810
复制相似问题