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".
