This discussion is archived
2 Replies Latest reply: Sep 22, 2011 11:33 AM by Sumant RSS

SQL Query execution with LISTAGG

Sumant Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points