This article explains SQL window functions ROW_NUMBER, RANK, and DENSE_RANK. It provides examples and syntax for each function and explains how to handle ties and gaps in ranking. The article also ...

This function will assign the unique Id to each row ... NUMBER() except the "equal" records are ranked the same. This will leave the gap of between the same values. please see the below result As we ...