0

before before

after after

tried few functions but didnt work

Paul T.
  • 4,703
  • 11
  • 25
  • 29
hshs
  • 13
  • 3

1 Answers1

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