Selecting Duplicates on All Fields
1
vote
0
answers
30
views
I have an MS Access (no laughing at the back) database I've used to import a bunch of IIS logs into.
Having looked at the Excel files I pulled these in from, I'm worried going by the dates that some of the IIS files might have full duplicates (i.e. where every single field is identical).
I know how to select duplicates on an individual row, but how can I issue an SQL query that will show me rows where **every** field is identical, so I don't get skewed results?
If possible, some guidance on how to then have these rows deleted from the table without having to do a million delete queries with the individual PK IDs would be great too.
Example data:
In the above I'd be looking to identify rows 1 and 2 as they are exact duplicates, but 3 and 4 are okay as they share some but not all values. So the report would ideally come back with 1 and 2, so I could then note the IDs and delete all but 1 of the duplicates.

Asked by user788561
(11 rep)
Jul 26, 2019, 02:52 PM
Last activity: Jul 30, 2019, 09:09 AM
Last activity: Jul 30, 2019, 09:09 AM