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

[siling99]

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

[liujia_0421]

for example:

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

[liujia_0421]

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));