How to delete all duplicate records except one record from Table #coding #shorts #sql #sqlqueries

How to delete all duplicate records except one record from Table #coding #shorts #sql #sqlqueries #programming #youtubeshorts

[RaviShankar-xyzh]

This is very good one. However a generic way to delete duplicates that works on any RDBMS would be better always. This works on every SQL database.
1. CREATE TABLE EMP_DUMP AS( SELECT DISTINCT * from employee);
2. Delete from employee.
3. Insert into employee values (select * from emp_dump);
4. Delete unwanted temple emp_dump.
however generic way is helpful when data of table is minimal or average.
Database specific way of doing deletion of duplicates is must when load of table is more.

[kusumal]

Deleting from cte will also delete from main table?