I have a table called, "subscribers".
It has many fields, but this question only concerns 2.
There are **many** duplicate records on the email field.
I want to deduplicate it.
One catch. I want to get rid of the duplicate records that have no value
Does that make sense?
I have the table backed up so I can play with this and try different things.
Thank you very much in advance.