Hi,
I have recently moved over to using SQLite and find it very good to manipulte data. One function I am having trouble with is using the LISTAGG function.
This is what it does in Oracle
name type
------------
name1 type1
name2 type2
name2 type3
SELECT name, LISTAGG(type, '; ') FROM table GROUP BY name ORDER BY name
Would result in:
name type
------------
name1 type1
name2 type2; type3
Is there a similar funtion in the SQLite library that I could use?
Kintara
p.s. I am using SQLDesktop.dll 1.51
I have recently moved over to using SQLite and find it very good to manipulte data. One function I am having trouble with is using the LISTAGG function.
This is what it does in Oracle
name type
------------
name1 type1
name2 type2
name2 type3
SELECT name, LISTAGG(type, '; ') FROM table GROUP BY name ORDER BY name
Would result in:
name type
------------
name1 type1
name2 type2; type3
Is there a similar funtion in the SQLite library that I could use?
Kintara
p.s. I am using SQLDesktop.dll 1.51
Last edited: