How could I search for duplicates records in a query

[hugheskbh]

I have to create a query to search an employee master file for employees that may have the exact same social security number. How can I do this in sql.

Thanks you

 

[venur]

Qry:

SELECT A.SSN, COUNT(DISTINCT A.SSN) COUNT
FROM EMPLOYEEMASTER A
GROUP BY A.SSN
HAVING COUNT(DISTINCT A.SSN) > 1

Hope this should help you,

Cheers
Venu

 

[jimbopalmer]

there are issues if there are more than two duplicates, but this would get you started

select a.SSN ,a.Full_Name, b.Full_Name from Emp_table a,emp_table b where a.SSN =b.SSN and a.rowid <> b.rowid;

to cope with many dupes

Select c.SSN, C.Full_name from emp_table c where c.SSN in (select a.SSN from Emp_table a,emp_table b where a.SSN =b.SSN and a.rowid <> b.rowid);

I tried to remain child-like, all I acheived was childish.