求Query解决思路

create table DBTest (OID int,Oname nvarchar(100),PID int,Com nvarchar(100))insert into DBTest values ('12345','ABC','364','CZZXXCC')insert into DBTest values ('12346','ABC','364','EZZXXEE')insert into DBTest values ('12350','DFGFG','362','CCZZXXDD')insert into DBTest values ('12351','DFGFG','365','EEZZXXFF')insert into DBTest values ('12355','XXCVD','362','WWZZXXD')insert into DBTest values ('12356','XXCVD','364','GGZZXXV')

SELECT a.* FROM dbtest a INNER JOIN dbtest b ON a.oname=b.onameWHERE a.pid<>b.pid/*OID         Oname                                                                                                PID         Com----------- ---------------------------------------------------------------- ----------- ----------------------------------------------------------------12351       DFGFG                                                                                                365         EEZZXXFF12350       DFGFG                                                                                                362         CCZZXXDD12356       XXCVD                                                                                                364         GGZZXXV12355       XXCVD                                                                                                362         WWZZXXD(4 行受影响)*/