/* First of all check whether the table has record or not */
1. Select * from Emp;
2. With temp as (Select row_number() over (order by column1, column2, column3) as row, column1, column2, column3 from Emp);
/* Now we will Delete the rows which are duplicates */
3. Delete from temp where row not in (select row from (select column1, column2, column3, MIN(row)
row
from temp a
group by column1, column2, column3) b);
/*Now again check the table */
4. Select * from Emp;
Hurrah!!!!!!!! All duplicate rows has been deleted!!!!!!!!!!
Hope it will help you��..
Have a nice day�