The DENSE_RANK function returns data ranking information and is similar to the RANK function. Its main difference is related to the results of identical line values. While the RANK function proceeds with the next row after providing the same value for identical consecutive rows (for example, 1,1,3), the DENSE_RANK function proceeds with the next number in the sequence (1,1,2).
The following shows the correct syntax for the DENSE_RANK function.
DENSE_RANK ( ) OVER (...)
Returns data ranking information.