- Only ordered lists without duplicates
The JSON path array accessor accepts a list of elements to pick:
SELECT JSON_QUERY('["A", "B", "C"]', '$[0,2]'
WITH ARRAY WRAPPER
)
FROM ...The JSON path expression [0,2] in this example returns the JSON elements "A" and "C".
Related
Primer: "JSON Path"
Other SQL/JSON path array accessors:
Last element:
[last]Ranges:
[... to ...]
Normative References
The SQL/JSON path language first appeared in ISO/IEC 9075-2:2016 as part of optional feature T833, "SQL/JSON path language: multiple subscripts".
