Glossary: SQL Beyond the Basics

Partition

Also written: PARTITION BY

One group of rows in a window, set by PARTITION BY. It works like GROUP BY except each row keeps its own row and sees only its group.