Using MySQL Window Functions

Window functions in MySQL allow you to return aggregate data for a subset of your results in a single query. In this session, we will define window functions and discuss use cases for when window functions might be appropriate. We will also break down the syntax of window functions, talk about the different clauses that can be used, and demonstrate the functionality of window functions and how the different clauses can return different results.