某一列重复的数据
查询出重复记录
select 重复记录字段 from 数据表 group by 重复记录字段 having count(重复记录字段)>1
多列同时重复的数据
select a.*
from xtcpb a ,(select cpb002,cpb006,cpb013,cpb018 from xtcpb
group by cpb002,cpb006,cpb013,cpb018 having count(*)>1) b
where a.cpb002=b.cpb002 and a.cpb006=b.cpb006
and a.cpb013=b.cpb013 and a.cpb018=b.cpb018