Sy-1148362 (11/30/2013)
Hi There!I have an Employee table with Columns:
EmpID | FirstName | MiddleName | LastName | SSN | BirthDate | HireDate | City | Zip
Requirement: I have to identify the duplicate records based on below criteria:
Criteria1: SSN
Criteria2: FirstName, LastName, BirthDate
Criteria2: FirstName, LastName, City, Zip
Please tell how to accomplish this task........Thanks in Advance
A search on this site would show you quite a few ways to identify duplicates.
The use of ROW_NUMBER or GROUP BY being a couple that come to mind.
With your criteria specified multiple times though you're not quite clear on how you would like to handle this.
Maybe posting what you've tried as has been suggested would give an idea of what you are actually trying to do.