SQL for Data Analytics

5. Window Functions for Data Analysis

Learning Objectives

By the end of this chapter, you will be able to:

• Explain what a window function is
• Write basic window functions
• Use common window functions to calculate statistics
• Analyze sales data using window functions and a window frame

In this chapter, we will cover window functions, functions similar to an aggregate function but that allow a new range of capabilities and insights.

Introduction

In the previous chapter, we discussed aggregate functions, functions that can take a large group of rows and output a single value for them. Often, being able to summarize a group of rows to a single value is important and useful. However, there are times when you want to keep the individual rows ...