sqlcmd.net validated sql reference

Tag archive

#pivot

Commands grouped around the same concept, pattern, or recurring problem.

2 commands with this tag Browse related patterns quickly
advanced reshaping MySQL MariaDB SQL Server PostgreSQL SQLite

Convert Columns to Rows With UNPIVOT

Reshape a wide table by turning multiple columns into key-value row pairs — the inverse of a PIVOT operation.

intermediate aggregation MySQL MariaDB SQL Server PostgreSQL SQLite

Pivot Rows Into Columns

Turn distinct row values into separate columns using `CASE WHEN` inside an aggregate.