Following are the queries that will delete all available duplicates in a table, please refer the query below Before deletion: Output: Alternatively, the same operation can be done using a CTE as sh…