What is the gap between `RANK()` values and what does that indicate about tied data?

Advanced SQL Developer Medium

Advanced SQL Developer — Medium

What is the gap between `RANK()` values and what does that indicate about tied data?

Key points

  • RANK() assigns the same rank to tied rows
  • Subsequent ranks are skipped based on the number of tied rows
  • The gap between ranks shows the number of rows that shared the previous rank position

Ready to go further?

Related questions