Dense Rank and Rank are SQL functions used to assign a rank to each row in a result set based on a specified criteria.

• Dense Rank assigns unique ranks to each row, leaving no gaps in the ranking sequen...read more

Dense_rank() over (order by "table_name")

Rank() over (order by " Table_name")

Rank skip the distinct value available in column and gives next ranking to the value

Where as dense rank will not skip any...read more