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 overloads

grade_up(list)

Scalar
Overload link list Returns
#01 ANY[] BIGINT[]

grade_up(list, sort_order)

Scalar
Overload link listsort_order Returns
#02 ANY[]VARCHAR BIGINT[]

grade_up(list, sort_order, null_order)

Scalar
Overload link listsort_ordernull_order Returns
#03 ANY[]VARCHARVARCHAR BIGINT[]

Example

grade_up example
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example · Run to view results.