ntile
ranking window function
Applies to: Databricks SQL Databricks Runtime
Divides the rows for each window partition into n buckets ranging from 1 to at most n
.
Returns
An INTEGER.
The default for n
is 1. If n
is greater than the actual number or rows in the window
You must use the ORDER BY clause with this function.
If the order is non-unique, the result is non-deterministic.