Did you try adding distinct
select DISTINCT a.lastname, a.firstname, a.permno, b.permno
from table as a
join table as b
on a.firstname=b.firstname
and a.lastname=b.lastname
where a.permno <> b.permno
Results 1 to 6 of 6
Thread: Find duplicates - Unique IDsHybrid View
|
|
|