Ask a simple sql statement question: how can you find out the repeated pieces of data in a table! Thank you

linbingdou

For example: the data in the table is 1 1 2 3 3 3
The results displayed after the query are: 1 1 3 3 3
Thank you

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