Episode-077 – Using Window Functions in MySQL Part 1

Window functions are powerful tools that can easily help us relate data in one row to data in related rows. In this video, we will demonstrate how to use the rank() function to determine the ranking of players in a data set.

Window Functions documentation – https://dev.mysql.com/doc/refman/8.4/en/window-functions.html

RANK() Documentation – https://dev.mysql.com/doc/refman/8.4/en/window-function-descriptions.html#function_rank

DENSE_RANK() Documentation – https://dev.mysql.com/doc/refman/8.4/en/window-function-descriptions.html#function_dense-rank