Click here to Skip to main content
15,076,991 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello All
Good Evening.

I have table name t1 and in it i have field just like with rows filled

email, name, city, country, mobile
a@a.a  Null   a      null    Null
b@b.b  c      c      Null    999..
a@a.a  b     Null     b      Null
a@a.a  Null  Null    Null    999..

Now, My question is: how can i find duplicate rows and then merge it in one row and after merging delete the remaining duplicate rows for that table?

Can anybody give me right solution how can i do like this?

Thanks in Advance. :)
Updated 29-Jul-10 4:23am

1 solution

Have a look at these articles:
How to remove duplicate rows from a table in SQL Server[^]
Removing Duplicate Records[^]

If needed, Google for more.
narendrarathod 29-Jul-10 10:38am
Thank you giving me your favorable reply, i am trying Google and read you suggested article.

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900