Sometimes we worked in places that don’t have Primary keys in some tables, when we need to delete some duplicated row, it’s impossible to select only one row.
If you don’t have any possibilities for changing table specifications, you can use this script.
It deletes duplicated rows in tables without Primary Key, it creates a temporary Id for deleting rows.
Download the script:
Script delete rows without key