ARRAY_REMOVE
Learn how to use the ARRAY_REMOVE array function in PlaidCloud Lakehouse. Removes all occurrences of a specified element from an array.
Removes all occurrences of a specified element from an array.
Analyze Syntax
func.array_remove([1, 2, 3, 2, 1], 2)
Analyze Examples
func.array_remove([1, 2, 3, 2, 1], 2)
┌─────────┐
│ [1,3,1] │
└─────────┘
SQL Syntax
ARRAY_REMOVE([1, 2, 3, 2, 1], 2)
SQL Examples
SELECT ARRAY_REMOVE([1, 2, 3, 2, 1], 2);
┌─────────┐
│ [1,3,1] │
└─────────┘