SQL数据重复查询

1.单字段重复查询

select * from tableName
where Words in (select Words from tableName group by Words having count
(Words) > 1)

2.多字段重复查询

SELECT a.* FROM tableName a,(
SELECT Words,Code FROM tableName 
GROUP BY Words,Code HAVING COUNT(1)>1
) AS b
WHERE a.Words=b.Words AND a.Code=b.Code