Forming SQL Query

See more:

SQL-Server

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. :)