Page tree
Skip to end of metadata
Go to start of metadata

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
  • No labels