JSON_ELEMENTS

Syntax

JSON_ELEMENTS(<string>;N)

Description

Returns the top N elements of a JSON array.

If N is left blank, all elements of the JSON array are returned.

Examples

Column 1NJSON_ELEMENTS returns
[a,b,null]1a
[a,b,null]2a, b
[a,b,null]3a, b, null