How to convert JSON to array of strings
Is it possible to use for json path
to format rows in a JSON array format?
I have a column like this
Col1
====
abc
def
ghi
jkl
and I want to format it like this
{"Col1":["abc","def","ghi","jkl"]}
I have so far gotten it to look like this
{["Col1":"abc","Col1":"def","Col1":"ghi","Col1":"jkl"]}
using this code
select col1 from table for json path