Can I use… [<e>, <e>, …] (SQL/JSON path array accessor)

1. 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:2016-2 as part of optional feature T833, “SQL/JSON path language: multiple subscripts”.