seperate by comma between values

Question

write a query below (see the below table table data)

empcolumn      empno

a         1

a         2

b         3

c         4

c         5

a         6

 

Output:

empcolumn      subjects

a                     1,2,6

b                      3

c                      4,5