Akhil Joshi
How to delete duplicate records based on single column from a table?
By Akhil Joshi in SQL Server on Oct 04 2012
  • anu jacob
    Oct, 2012 18

    DELETE FROM table_name WHERE col_name IN ( SELECT col_name FROM table_name GROUP BY col_name HAVING Count(col_name)>1) DELETE FROM emp WHERE ename IN (SELECT ename FROM emp GROUP BY ename HAVING Count(ename)>1)

    • 1
  • Lalit Raghuvanshi
    Feb, 2015 5

    Please refer the article Remove duplicate records/data from Sql Server database table http://www.webcodeexpert.com/2013/11/how-to-remove-duplicate-recordsdata.html

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS