You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Delete duplicate emails from Contacts_list

Received Response

Hi all,

How could I create a sql to return duplicate email_address_, opt-In, deliverable, with riid_
Our intention is to delete duplicate emails and leave only the one created with the oldest date.

I have this example, but it returns the full list and without riid_

select email_address_, count(*) total from $A$

group by email_address_

order by count(*) desc

it's possible? Can you help me please!

Many thanks!

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!