Monday 13 February 2017

update multiple row if we have duplicate record in sql

UPDATE T1 SET Col1=Col1+CAST(EmpId AS VARCHAR)
WHERE EmpId NOT IN (
  SELECT MIN(EmpId)
  FROM T1
  GROUP BY Col1
);

No comments:

Post a Comment