How can I find duplicates in SQL 2008

Question

I need to find duplicate entries of the value 3 in the Status column and delete all rows containg the value of 3? I updated the rows easily but cant figure out how to find the duplicates and get rid of them. Im a rookie. Thanks

Status is my last column.

                                                        status
17657   0000200133   17714   0000200133   0000200133    3
17657   0000200133   17714   0000200133   0000200133    1

Answer 1

0

Hi rookie,

I didnt get your Question clearly. Below query is useful for the remove the duplicate rows except master . I think it will useful for you.

WITH TempTable AS 
      ( 
           SELECT   Empno, row_number() OVER ( PARTITION BY Empno ORDER BY Empno) AS ID
               FROM tabEMP
       )
    Delete from TempTable  WHERE  ID > 1

answered Sep 21 '12 at 07:29 AM

Krishjkc
40

(comments are locked)

How can I find duplicates in SQL 2008

Follow this question

Related Questions