LISTAGG
Does Active Query Builder provide the ability to parse LISTAGG functions?
Replies 6
WITH c1 AS(SELECT1 AS ID, 'Bananas' PNAME
FROM dual),
c2 AS(SELECT2 AS ID,
'Apples' PNAME
FROM dual),
c3 AS(SELECT2 AS ID,
'Peaches' PNAME
FROM dual)
SELECT ListAgg(d3.ID ||': '|| d3.PNAME,', ') WITHIN GROUP(ORDER BY
d3.ID, d3.PNAME)AS LIST1
FROM(SELECT c1.ID,
c1.PNAME
FROM c1
UNION ALL
SELECT*
FROM c2
UNION ALL
SELECT*
FROM c3) d3
FROM dual),
c2 AS(SELECT2 AS ID,
'Apples' PNAME
FROM dual),
c3 AS(SELECT2 AS ID,
'Peaches' PNAME
FROM dual)
SELECT ListAgg(d3.ID ||': '|| d3.PNAME,', ') WITHIN GROUP(ORDER BY
d3.ID, d3.PNAME)AS LIST1
FROM(SELECT c1.ID,
c1.PNAME
FROM c1
UNION ALL
SELECT*
FROM c2
UNION ALL
SELECT*
FROM c3) d3
Hello,
Have a look for various solutions for this problem here:
https://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/
Quick answer:
http://stackoverflow.com/questions/15154644/group-by-to-combine-concat-a-column
Hello,
You asked:
Active Query Builder has support for LISTAGG with Oracle SQL syntax, but it doesn't have support for it with DB2.
With what SQL syntax you need to use this function?