Delete query question

  • Thread starter Thread starter Support
  • Start date Start date
S

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
 
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!
 
Back
Top