DELETE DUPLICATE VALUES IN TABLE

Posted by Sriramnandha under Sql Server category on 5/21/2012 | Points: 40 | Views : 1942

DELETE TABLE WHERE EMPID IN(SELECT EMPID FROM EMPLOYEE GROUP BY EMPID 

HAVING COUNT(*)<1)

REGARDS

Bookmark It

Latest Code Snipptes