请教一个简单sql语句问题:怎么能够查出一个表里的重复的各条数据呀!谢谢了

linbingdou

例如:表里的数据是 1   1   2   3   3    3  
查询后显示的结果为: 1   1    3   3     3
谢谢了

kalian2000

for example:

select * from test where id in (select * from test group by id having (count(id)>1));

kalian2000

test:


create table test(id int)

insert into test values(1)
insert into test values(1)
insert into test values(2)
insert into test values(3)
insert into test values(3)
insert into test values(3)

select * from test where id in (select * from test group by id having (count(id)>1));