17,082
社区成员
发帖
与我相关
我的任务
分享关于用sql找出重复记录的问题
对一张表table搜索重复的A字段,用 select A from table得出的总共记录数为1056,
再用 select distinct A from table 得出的总共记录数为1055,可知table中有两条记录A是重复的,可是如何用sql找出这两条重复的记录呢?
再用 select distinct A from table 得出的总共记录数为1055,可知table中有两条记录A是重复的,可是如何用sql找出这两条重复的记录呢?
...全文
请发表友善的回复…
发表回复
intel0001 2003-03-13
- 打赏
- 举报
感谢大家.
beckhambobo(beckham)的方法最好,一步就求出来了,简单明了.
bzszp(SongZip)的sql应该改为
select * from(select count(1) cc ,a.a from a group by a.a) b where b.cc>1;
似乎不太简洁.
supershb(phenix) 的sql我不太理解.
beckhambobo(beckham)的方法最好,一步就求出来了,简单明了.
bzszp(SongZip)的sql应该改为
select * from(select count(1) cc ,a.a from a group by a.a) b where b.cc>1;
似乎不太简洁.
supershb(phenix) 的sql我不太理解.
sunnygc 2003-03-13
- 打赏
- 举报
select a from table group by a having count(1)>1;
llm06 2003-03-13
- 打赏
- 举报
select * from table group by a having count(a)>1
beckhambobo 2003-03-13
- 打赏
- 举报
sorry,
select a from table group by a having count(1)>1;
select a from table group by a having count(1)>1;
bzszp 2003-03-13
- 打赏
- 举报
select * from(select count(1) cc ,a.a from a group by a) b where b.cc>1;
beckhambobo 2003-03-13
- 打赏
- 举报
select a from table group by a having count(1)=1;
supershb 2003-03-13
- 打赏
- 举报
select * from table
where exists(selet * from table t
where t.pk1 = table.pk1
and t.pk2 = table.pk2
...
and t.pkn = table.pkn)
--pk-->primary key
where exists(selet * from table t
where t.pk1 = table.pk1
and t.pk2 = table.pk2
...
and t.pkn = table.pkn)
--pk-->primary key
