delete from table1 where EmpID in(select cId from table1 group by cid having count(*) >1)
Showing posts with label get only unique value in sql server. Show all posts
Showing posts with label get only unique value in sql server. Show all posts
get only unique row and delete all duplicate row
Subscribe to:
Posts (Atom)