[last] (SQL/JSON path array accessor)

The JSON path accessor [last] picks the last element of a JSON array.

SELECT JSON_VALUE('["A", "B", "C"]', '$[last]')
  FROM …

The JSON path expression [last] in this example returns the value "C" as it is the last element in the JSON array.

Related

• Primer: “JSON Path”

• Other SQL/JSON path array accessors:

  • Multiple subscripts: [<e>, <e>, …]

  • Ranges: [… to …]

Normative References

The SQL/JSON path language first appeared in ISO/IEC 9075-2:2016 as part of optional feature T821, “Basic SQL/JSON query operators”.