Glossary: SQL Beyond the Basics

Window function

Also written: window functions

A function computed over a set of related rows that keeps every row and adds the value alongside, unlike GROUP BY. It is made by adding OVER (…) and can't be used in WHERE.