delete all but oldest duplicate

[EchoAlertcom]

Hello.

Do I have this statement correct if I want to delete all but the oldest of duplicate records?

delete from dbo.customers
where dbo.customers.UID != 
		(Select MIN(UID) from dbo.customers adb
			where adb.emailaddr = dbo.customers.emailaddr)

Thank you,
Steve

 

[DrSql]

Its tough to tell you the data you want to delete is correct or not.
Try the below script audit few records thats the data you want to delete. Backup the table some where prior to that


Select *
from dbo.customers
where dbo.customers.UID !=
(Select MIN(UID) from dbo.customers adb
where adb.emailaddr = dbo.customers.emailaddr)


Dr.Sql
Good Luck.