What is "PIVOT" in SQL?

Question

What is "PIVOT" in SQL?

Answer 1

PIVOT is a SQL technique for rotating the data from rows to columns. It's particularly useful for transforming data that is organized in a stacked format (where multiple values for a column are stacked in a single row) into a pivoted format (where each value becomes a separate column).

Answer 2

PIVOT is a type of JOIN operation used to combine data from multiple tables.

Answer 3

PIVOT is one of SQL aggregation functions

Practice

Lessons

Playground

Test

What is "PIVOT" in SQL?

Login

Register

What is "PIVOT" in SQL?