Delete duplicate records (keep last duplicate data):
Delete table where primary key ID not in (select MAX ([primary key ID]) from table group by (duplicate field one + duplicate field two))
Delete duplicate records (keep first duplicate data):
Delete table where primary key ID not in (select min ([primary key ID]) from table group by (duplicate field one + duplicate field two))
Finds all duplicate data for a database that does not include the last row of duplicate data:
SELECT * FROM table where primary key ID not in (select MAX ([primary key ID]) from table group by (duplicate field one + duplicate field two))
Finds all duplicate data for a database that does not include duplicate data from the first row:
SELECT * FROM table where primary key ID not in (select min ([primary key ID]) from table group by (duplicate field one + duplicate field two))
Find the last line of duplicate data:
SELECT * FROM table where primary key ID in (select MAX ([W_SN]) from table group by (duplicate field one + duplicate field II))
Find the first row of duplicate data:
SELECT * FROM table where primary key ID in (select min ([W_SN]) from table group by (duplicate field one + duplicate field II))