Cacher is the code snippet organizer for pro developers

--RUn this query more than 1 time to delete all the duplicates--
DELETE FROM table1 
WHERE id IN ( 
     SELECT MIN(id) FROM table1 --you can delete the MIN or MAX based on ID
     GROUP BY col1, col2, col3 --columns which makes it to duplicate
     -- could add a WHERE clause here to further filter
     HAVING count(*) > 1
)

select ListingID, count(*)
  from Listing
  group by ListingId
  having count(*) > 1