Select
id,
title
FROM
A
Where
title IN (
Select
title
FROM
A
GROUP BY
title
HAVING
COUNT(*) > 1
)
ORDER BY
title, id;
直接筛选出ID TITLE
直接操作mysql表
用TITLE重复部份去快速查找本地，选出本地重复切走。
读完这篇文章后，您心情如何？
Select
id,
title
FROM
A
Where
title IN (
Select
title
FROM
A
GROUP BY
title
HAVING
COUNT(*) > 1
)
ORDER BY
title, id;
直接筛选出ID TITLE
直接操作mysql表
用TITLE重复部份去快速查找本地，选出本地重复切走。