ntile()

The row bucket in a window partition for a given bucket count

Reference: DuckDB 2.0.0

Arguments & returns

ntile(num_buckets)

window
Overload link num_buckets Returns
#01 BIGINT BIGINT

Example

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

Engine example with sample data · Run to view results.