Ways to Find and Deleting Dupliacte records IN SQL SERVER ?

[deveshakgec]

Ways to Find and Deleting Dupliacte records IN SQL SERVER
I have solution here...

Consider table emp
Column: ID,C1,C2


1) WE ARE CONSIDER IF ID AS IDENTITY COLUMN

DELETE FROM EMP WHERE ID NOT IN (SELECT MAX(ID) FROM EMP GROUP BY C1 ,C2)

2) USING ROW_NUMBER()


Consider table emp
Column: ID,name

DELETE EMP_T FROM (SELECT ROW_NUMBER() OVER PARTATION BY (ID,NAME) ORDER BY ID) AS ROWID FROM EMP) EMP_T
WHERE EMP_T.ROWID >1

3)USING CTE

WITH CTE AS {

SELECT ID,NAME , ROW_NUMBER() OVER (PARTATION BY ID,NAME )AS RANK FROM EMP)
}
DELTE FROM CTE WHERE RANK>1

[Rabbit]

Please use code tags when posting code or formatted data.

Please read our FAQ on the rules to follow when posting on this forum.

What is your question? You seem to have answered yourself.

[ck9663]

I think he posted this (and the other posts) as articles.

~~ CK

[deveshakgec]

Hello,

I will take care from next time.