Hi all,
I define my problem with a small example below.
I will have SQL result set as shown below
Quote:
NAME PHONE_NUMBER
------ ----------------
AAAA 11111111111111
AAAA 22222222222222
BBBB 11111111111111
But I need it as
Quote:
NAME PHONE_NUMBER
------ ---------------------------------
AAAA 11111111111111,22222222222222
BBBB 11111111111111
Phone Number column should be joined together for every employee with , delimited value as shown above.
I have done this using Function ( User Defined Function ) in DB2 at database level in the past. But Now I am using Hibernate (with MySQL 5.6 ) because of DB Dialect , So any help to achieve this just by using Hibernate.
Any suggestion please.
Regards,
Arun