SQL Ranking Window Function Guide

ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(), PERCENT_RANK(), CUME_DIST()

In the world of SQL queries, we often find ourselves needing to create some sort of ranking to better understand our data. Luckily for us, ranking functions are one of the major domains under the umbrella of Window Functions, and can be easily implemented!

The six types of ranking functions are:

• ROW_NUMBER()
• RANK()
• DENSE_RANK()
• PERCENT_RANK()
• NTILE()
• CUME_DIST()

Before we get into the details of each ranking function, we should look into how these functions …

database data science mysql postgres sql