Query containing Logic

Question

 empno     emailID
--------------------
1           [email protected]
2           [email protected]
3           [email protected]
2           [email protected]
1           [email protected]
1           [email protected]
3           [email protected]

Write a query so that result will be :--

 empno     emailID
--------------------
1           [email protected],[email protected],[email protected]
2           [email protected],[email protected]
3           [email protected],[email protected]

Answer 1

What you are looking for is called GROUP_CONCAT in MySQL and looks like this:

SELECT empno, GROUP_CONCAT(emailID)
FROM yourtable
GROUP BY empno

Unfortunately GROUP_CONCAT does not exist in SQL Server but you can use FOR XML PATH or one of the other workarounds posted as answers to this question.