MariaDB and MySQL Common Table Expressions and Window Functions Revealed

© 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. ...