ARRAY_TOP_N
Returns the top N elements from an array.
Analyze Syntax
func.array_top_n([3,1,4,1,5], 3)
Analyze Examples
func.array_top_n([3, 1, 4, 1, 5], 3)
┌─────────┐
│ [5,4,3] │
└─────────┘
SQL Syntax
ARRAY_TOP_N([3,1,4,1,5], 3)
SQL Examples
SELECT ARRAY_TOP_N([3, 1, 4, 1, 5], 3);
┌─────────┐
│ [5,4,3] │
└─────────┘