Delete query question

[Support]

I have a "find duplicate" query which returns a list of users who are the
same but have different registration dates (ie they have registered more
than once therefore have different user id's).
How do I create a delete query that will delete the earliest date?
Many thanks

 

[Support]

think I've sorted this.
I only had a small amount of dupes (2246) so I ran a query to give a MAX
date value, export this then delete all the dupes and re-import the MAX date
value.
fingers crossed!

 

[Support]

hmm maybe not actually.