查询某些字段的重复记录
select a.col1,a.col2 from tablename a,
(select col1,col2 from tablename group by col1,col2 having count(*)>1) b
where a
查询某些字段的重复记录
select a.col1,a.col2 from tablename a,
(select col1,col2 from tablename group by col1,col2 having count(*)>1) b
where a