2 Replies Latest reply: Sep 22, 2011 1:33 PM by Sumant RSS

    SQL Query execution with LISTAGG

    Sumant
      Hello,
      I am trying to get some data using LISTAGG functionality.
      I have below query with works fine with the table, but not with the rowsource which is based on same table.
      SELECT COL1,LISTAGG(COL3, ',') WITHIN GROUP (ORDER BY COL2) AS fieldName FROM IOP_Sample_RS GROUP BY COL1
      it gives parsing error
       line 1:22: expecting "FROM", found '('
      col 22 is '(' of LISTAGG function.

      One more Question

      Does UNION, MINUS works with RSQL in IOP?
      Thanks,
      Sumant Chhunchha.

      Edited by: Sumant on Jun 15, 2011 5:04 AM