DELETE DUPLICATE VALUES IN TABLE

Sriramnandha
Posted by Sriramnandha under Sql Server category on | Points: 40 | Views : 1146
DELETE TABLE WHERE EMPID IN(SELECT EMPID FROM EMPLOYEE GROUP BY EMPID 

HAVING COUNT(*)<1)


REGARDS

Comments or Responses

Login to post response