I am using mysql , Table with 2 Columns
Col1 | Col1
------+-------+
a@a | ab |
a@a | cd |
b@b | ab |
b@b | cd |
I want result like this
Col1 | Col1
------+--------+
a@a | abcd |
b@b | abcd |
How can i achieve this using SQL please help me. Thanks.