Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Location
    Ottawa, Canada
    Posts
    58

    Unanswered: Group_Concat in DB2

    Is there an equivalent aggregate function in DB2 for the MySQL function GROUP_CONCAT?

    group_concat returns a string result with concatenated values from a group.

    example...

    SELECT student_name,
    -> GROUP_CONCAT(test_score)
    -> FROM student
    -> GROUP BY student_name;


    Tom , (3,4,4,3,2) <-- concatenated from the group
    Ted, (4,54,3,34,)

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    No, there's no such function in DB2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •