The function DENSE RANK returns the rank of a row in an ordered collection of rows as a NUMBER. The ranks are in ascending order, starting with 1. The number of unique values returned by the query is the highest rank value.