Skip to content

Glossary: SQL Beyond the Basics

Pivot

Also written: pivot table

A summary with one row per group and one column per category, such as cafés and online side by side for each state. It is built with conditional aggregation.

Where the book teaches it

Related terms

Conditional aggregation