What you are looking for is an "autojoin", i.e. joining a table to itself. SELECT a.* from person a join person b on (a.name = b.name and a.person_no <> b.person_no);
What you are looking for is an "autojoin", i.e. joining a table to itself. SELECT a.* from person a join person b on (a.name = b.name and a.person_no <> b.person_no);