PostgreSQL Summary Stats and Window Functions

In this chapter, you'll learn what window functions are, and the two basic window function subclauses, ORDER BY and PARTITION BY.

In this chapter, you'll learn three practical applications of window functions: fetching values from different parts of the table, ranking rows according to their values, and binning rows into different tables.

In this chapter, you'll learn how to use aggregate functions you're familiar with, like AVG() and SUM(), as window functions, as well as how to define frames to change a window function's output.

In this last chapter, you'll learn some techniques and functions that are useful when used together with window functions.