As you can see from the cmd - i want to delete all duplicates however i want to keep at least one?
e.g. if i have 3 duplicate then i only want to delete 2 etc
NB: Please ignore the declare - its not relevant and i'm unable to edit code snippit
declare @source UniqueIdentifier
where email in
SELECT email FROM [user]
GROUP BY email
HAVING (COUNT(email) > 1 )