Rank assigns unique ranks to each distinct value, while dense rank assigns consecutive ranks to each distinct value.

• Rank leaves gaps between ranks if there are ties, while dense rank does not

• Rank func...read more