Hi,

I need to write a query for the problem defined below. Can anyone help me ?

Input table
T1

Emp NO Emp Name Depedent Sex
312 a z m
312 a y m
312 a x f
423 b k m
423 b j f
234 c l m

out put should be printed as

Emp no Emp name Dependent
312 a z,y,x
423 b k,j
234 c l

Please give me query to print the output specified as above.