Query to remove true duplicates

• Identify the columns that define a unique record

• Use GROUP BY to group the records by those columns

• Use HAVING to filter out groups with more than one record

• Use DELETE to ...read more