I have a table of data and there are many duplicate entries from user submissions.
I want to delete all duplicates rows based on the field subscriberEmail, leaving only the original submission.
In other words, I want to search for all duplicate emails, and delete those rows, leaving only the original.
How can I do this without swapping tables?
My table contains unique IDs for each row.