Working With DENSE_RANK()
DENSE_RANK()
is a window function that assigns a rank to each row within a partition or result set with no gaps in ranking values. A simple example is shown here:
Let's assume that we want to rank employees (EMPLOYEE
) in offices (OFFICE
) by their salary (EMPLOYEE.SALARY
). Expressing this via jOOQ and DENSE_RANK()
can be done as follows: