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 in MySQL Part 2 - https://youtu.be/AYYdlz7hvEQ
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
Window Functions in MySQL Part 2 - https://youtu.be/AYYdlz7hvEQ
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
- Category
- MySQL
- Tags
- MySQL, Database, Open-source
Be the first to comment


