Deleting duplicate rows in a table

Question

0.00/5 (No votes)

See more:

SQL

server

Hi friends,

Please tell me how to delete a duplicate row in a table?

Posted 21-Jul-11 9:15am

Member 7920084

Add a Solution

Comments

Uday P.Singh 21-Jul-11 15:23pm

your question is not clear, give table structure and what do you want?

Member 7920084 21-Jul-11 16:35pm

I have created a table and entered some duplicate rows into that table. Now I want to find out duplicate rows and delete them..

3 solutions

Solution 1

SQL

DELETE FROM Table1 WHERE Col1 NOT IN (SELECT MIN(Col1) FROM Table1 GROUP BY DupCol1, DupCol2, DupCol3)

Posted 21-Jul-11 9:18am

Shameel

Comments

[no name] 22-Jul-11 0:41am

Wondering why my answer was downvoted!!!

Solution 3

I'm on my phone now so can't help properly, but check out sqlservercentral.com. I remember someone asking that question there and it was resolved =D

Posted 21-Jul-11 9:32am

Gordon Beeming

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Uday P.Singh · Accepted Answer · 2011-07-21T09:30:00

Solution 2

check this out:

sql-server-2005-2008-delete-duplicate-rows[^]

How_to_Delete_Duplicate_Records_from_an_SQL_Server_Table.html[^]

hope it helps :)

Posted 21-Jul-11 9:30am

Uday P.Singh

Updated 21-Jul-11 9:37am

v2

Deleting duplicate rows in a table

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0

Deleting duplicate rows in a table

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us