tried few functions but didnt work
Asked
Active
Viewed 288 times
1 Answers
0
Some databases (like MySql or MariaDb) support a group_concat() function that can be used in conjunction with GROUP BY:
select
id,
group_concat(distinct value separator ',')
from table
group by id
Some other databases may have a similar function with a different name (STRING_AGG() for example), try to check your db documentation...

Liutprand
- 527
- 2
- 8