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_5

5. Recognizing Opportunities for Window Functions

Daniel Bartholomew¹ 

(1)

Raleigh, North Carolina, USA

 

The previous chapter was an overview of what Window Functions are, with details on the syntax. It’s time to put that knowledge into practice. This chapter expands upon that with some simple yet practical examples that illustrate some of the types of problems Window Functions are good at solving. We’ll cover organizing results, maintaining running totals, and ranking results.

Caution

If you are using MySQL 8.0, you must be on at least version 8.0.2. This was the version that introduced Window ...