dense_rank()

The rank of the current row without gaps

Reference: DuckDB 2.0.0

Arguments & returns

dense_rank()

window
Overload link Returns
#01 BIGINT
dense_rank example
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example with sample data · Run to view results.

More examples

dense_rank example 2
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Guide example · Run to view results.