I need function, that returns list of strings.
I have data in table like this:
Id MyString
------------------------
1 First
2 Second
3 Third
4 Fourth
I need function like this (something like this works in oracle):
select LISTAGG(MyString, ', ') as myList where id < 4
That returns something like this:
myList
------------------------
First, Second, Third
Any ideas?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…