Using MySQL Window Functions
Talk by Nisha Riyaj
https://www.socallinuxexpo.org/scale/...
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.