Remove duplicates in a query

corptkm asked on
I have two columns...

The first columns have machine names and the second column is the user who owns that machines

I would like to run a query that deletes all the dups...keeping only one of them.
So if you have four machine names and four of the same user names. I want it to find all the machine names and delete all except for one.

How do I do that?

I did a query wizard "find match" but it wont keep one of each.
1 person had this question

Abuse history