The JSON path array accessor accepts a range of elements to pick:
SELECT JSON_QUERY('["A", "B", "C"]', '$[1 to 2]'
WITH ARRAY WRAPPER
)
FROM …The JSON path expression [1 to 2] in this example returns the JSON elements "A" and "B".
Related
Primer: “JSON Path”
Other SQL/JSON path array accessors:
Last element:
[last]Multiple subscripts:
[<e>, <e>, …]
Normative References
The SQL/JSON path language first appeared in ISO/IEC 9075:2016-2 as part of optional feature T821, “Basic SQL/JSON query operators”.
