© Daniel Bartholomew 2017Daniel BartholomewMariaDB and MySQL Common Table Expressions and Window Functions Revealedhttps://doi.org/10.1007/978-1-4842-3120-3_6
6. Window Functions in Practice
Raleigh, North Carolina, USA
This chapter contains several examples that demonstrate using Window Functions in the real world. We’ll start with a demonstration of using them multiple times in the same query to see how the WINDOW clause makes this simple and easy to read. Next, we’ll explore using Window Functions to help us when we graph time-series data. Lastly, we’ll use Window Functions to analyze sales data.
The examples in this chapter utilize sample data you can use to follow along with the text and experiment with. ...