Skip to main content

ARRAY_REMOVE_FIRST

Removes the first element from the array.

Syntax

ARRAY_REMOVE_FIRST( <array> )

Examples

SELECT ARRAY_REMOVE_FIRST([1, 2, 3]);

┌───────────────────────────────┐
│ array_remove_first([1, 2, 3])
├───────────────────────────────┤
[2,3]
└───────────────────────────────┘
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today