Lists & arrays
Scalar
grade_up()
Works like list_sort, but the results are the indexes that correspond to the position in the original list instead of the actual values.
Reference: DuckDB 2.0.0
Alias of list_grade_up()
Arguments & returns
3 overloadsgrade_up(list)
Scalar
| Overload link | list |
Returns |
|---|---|---|
| #01 | ANY[] |
BIGINT[] |
grade_up(list, sort_order)
Scalar
| Overload link | list | sort_order |
Returns |
|---|---|---|---|
| #02 | ANY[] | VARCHAR |
BIGINT[] |
grade_up(list, sort_order, null_order)
Scalar
| Overload link | list | sort_order | null_order |
Returns |
|---|---|---|---|---|
| #03 | ANY[] | VARCHAR | VARCHAR |
BIGINT[] |
Example
Haybarn WASM 2.0.0-rc12 · In your browser
Engine example · Run to view results.