What SQL query would you use to find duplicate rows in a table and remove them while keeping one record per duplicate group?
