ARRAY_DIFFERENCE
Returns an array of differences between consecutive elements.
Analyze Syntax
func.array_difference([1, 3, 6, 10])
Analyze Examples
func.array_difference([1, 3, 6, 10])
┌───────────┐
│ [0,2,3,4] │
└───────────┘
SQL Syntax
ARRAY_DIFFERENCE([1, 3, 6, 10])
SQL Examples
SELECT ARRAY_DIFFERENCE([1, 3, 6, 10]);
┌───────────┐
│ [0,2,3,4] │
└───────────┘