© Daniel Bartholomew 2017
Daniel 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

Daniel Bartholomew
(1)
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.

Before We Begin

The examples in this chapter utilize sample data you can use to follow along with the text and experiment with. ...

Get MariaDB and MySQL Common Table Expressions and Window Functions Revealed now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.