Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

...

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

Further Documentation

Find more documentation on working with JSON here.