select * from table where field1 + field2 + field3 in 
(
	select field1 + field2 + field3 from table group by field1 + field2 + field3 having count(*) > 1
) 
and uniqueID not in 
(
	select MAX(uniqueID) from xer_regis_new group by field1 + field2 + field3 having count(*) > 1
)

Field1 + Field2 + Field3 should create 1 entry for each unique row in the DB. In an employee table, this would be FirstName + LastName + EmployeeNumber

Find Duplicate Rows in Table

database, sql

SQL