Skip to main content

TAKE

TAKE returns the first N elements from a list.

Syntax​

TAKE(list, count)

Parameters​

  • list – List value.
  • count – Number of elements to take. Must be a non‑negative integer.

Examples​

SELECT TAKE(CAST('[1,2,3,4,5]' AS LIST), 3);

This returns [1, 2, 3].