1. Forum
  2. Usenet
  3. COMP.DATABASES.INFORMIX

  • Sql to concatenate multiple rows to a single row / column

    From vignesh K@21:1/5 to All on Fri Jul 8 04:45:42 2022
    Is there a way of concatenating the results from one column / multiple
    rows into a one column / one row?

    Problem:

    I have a Grade table with following columns

    grade_id
    grade_val

    grade_id grade_val
    =================
    1 25
    2 45
    3 63

    How can i write a query to generate the following result

    grade_val
    25,45,63

    I'm used listagg,group_concat but it raised error on
    Sql Error -674: Routine (listagg) can not be resolved.

    Any help would be greatly appreciated.
    Thanks !

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)