SQL query to delete duplicate records from a table.

• Use the DELETE statement with a subquery to identify and delete duplicate records.

• The subquery should select the duplicate records based on the crite...read more

Select Distinct * from table;

SELECT DISTINCT * FROM EMP;

SELECT DISTINCT * FROM EMP;

select DISTINCT * FROM EMP;

delete from table_name where rowid not in (select max(rowid) from table_name grroup by column_name);

Delete employee where rowid in(select rowid from(select m. *, row_number() over(partion by id, order by salary) r, rowid from employee m)

Where r<>1)

delete from employee(tablename) where ROWID not in (select min(rowid)from employees(tablename) group by empid (columnname));