Episode-077 - Using Window Functions in MySQL Part 1

60 Views
Published
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
Category
MySQL
Tags
MySQL, Database, Open-source
Be the first to comment