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