Rank assigns unique ranks to each row, while dense rank assigns consecutive ranks without gaps.

• Rank leaves gaps in rank numbers if there are ties, while dense rank does not

• Rank function is non-consecu...read more