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
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.