How to delete Duplicate records from a Table in SQL Server

Hi Kantikh,

You need to select all the distinct data to temp table and then delete all the data from the base table and then reinsert the data from the temp table as following

SELECT DISTINCT * 
INTO #temp
FROM emp

TRUNCATE TABLE emp
--DELETE emp

INSERT INTO emp
SELECT * FROM #temp

DROP TABLE #temp

Thanks and Regards,

Rk_Hirpara