Advanced SQL Developer — Medium
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
