如何找出重复数据？？？
表A中有一字段X，如何找出内容重复的X？？？ 问题点数：100、回复次数：4Top
1 楼bzszp（SongZip）回复于 2003-01-08 10:01:49 得分 70
说清楚一些，
select X from (select X,count(*) num from A group by colname)
where num>1;Top
2 楼ouygg（痞子酷）回复于 2003-01-08 10:09:21 得分 20
select keyField, count(x) from a
group by keyField
having count(x)>1;Top
3 楼hrb_qiuyb（晨钟暮鼓）回复于 2003-01-08 10:23:04 得分 10
这select X,count(*) from A
group by x
having count(*)>1
Top
4 楼Uoooo（羽毛）回复于 2003-01-21 19:33:45 得分 0
1 select msis from zhyw.tj_2002 a where msis is not null and
2 exists (select 1 from zhyw.tj_2002 b where a.msis = b.msis
3* and group by b.msis having count(*) >1)Top
