Another possibility: sqlite> create table a(id,name); sqlite> insert into a values (1,'john'), (2,'john'), (3,'ann'), (4,'pete'); sqlite> select * from a where name in (select name from a group by name having count(*) > 1); 1|john 2|john Gerry
Another possibility: sqlite> create table a(id,name); sqlite> insert into a values (1,'john'), (2,'john'), (3,'ann'), (4,'pete'); sqlite> select * from a where name in (select name from a group by name having count(*) > 1); 1|john 2|john Gerry