select
*
from
table a
inner join
(select id,address,bcdid from table group by address,bcdid having count(*) > 1) b
on a.id != b.id
and
a.address = b.address
and
a.bcdid = b.bcdid
)
select
*
from
table a
inner join
(select id,address,bcdid from table group by address,bcdid having count(*) > 1) b
on a.id != b.id
and
a.address = b.address
and
a.bcdid = b.bcdid
)