Delete duplicate row from the table

Question

How can we delete duplicate row from the table through the SQL query ?

Anil Kumar · Answer

There are many ways to delete duplicate records/rows. Refer: Removing Duplicates from a Table in SQL Server Using JOIN a good example can be found @ SQL Query to get rid of duplicate records

Satyapriya Nayak · Answer

Hi Shubham STEP 1 - Insert your distinct data into a temporary table select distinct * into temp from TableName STEP 2 - Delete From TableName STEP 3 - Insert TableName Select * From temp Write three step and remove duplicate values from your tables. Thanks

saisagar nalla · Answer

use distinct keyword in your query.. ex: select distinct(empname) from employee