1.查询单列重复:
select * from test where name in (select name from test group by name having count(name) > 1)
2.查询多列重复:
Select a.* FROM test a,( Select name,code FROM test GROUP BY name,code HAVING COUNT(1)>1 ) AS b Where a.name=b.name AND a.code=b.code