DENSE_RANK
Examples
select
id,
salary,
dense_rank() over (order by salary)
from employee
order by salary;
Result
id salary dense_rank -- ------ ---------- 3 8.00 1 4 9.00 2 1 10.00 3 5 10.00 3 2 12.00 4
DENSE_RANK
Examplesselect
id,
salary,
dense_rank() over (order by salary)
from employee
order by salary;
id salary dense_rank -- ------ ---------- 3 8.00 1 4 9.00 2 1 10.00 3 5 10.00 3 2 12.00 4
NTILE()
Distributes the rows of the current window partition into the specified number of tiles (groups)
BIGINT
NTILE ( number_of_tiles ) OVER <window_name_or_spec>
Argument | Description |
---|---|
number_of_tiles |
Number of tiles (groups).Restricted to a positive integer literal, a named parameter (PSQL), or a positional parameter (DSQL). |