What is pivot?

Turn rows into columns.

What is pivot?

Pivot turns rows into columns. It produces wide-format reports.

-- satır: ay, değer: ciro
-- pivot: her ay bir sütun

From month rows to month columns.

What is pivot? — details

With pivot you produce a column per category. Done with CASE and aggregates.

For example, you turn a monthly sales table into a report with each category in its own column: rows are months, columns are Books, Electronics, Clothing.

Exercise What is pivot?

Create a pivot column for each category with CASE WHEN category = 'Kitap' THEN amount ELSE 0 END.

Show example solution

SELECT
  SUM(CASE WHEN category = 'Kitap' THEN amount ELSE 0 END) AS Kitap,
  SUM(CASE WHEN category = 'Elektronik' THEN amount ELSE 0 END) AS Elektronik
FROM sales;

Test yourself

What does pivot turn into columns?
- Triggers
- Tables
- Indexes
- Rows
Show answer

Rows — Pivot turns rows into columns.
Pivot
```
row → ____
```
Show answer
```
row → column
```
What is pivot: match the terms

pivot

row→column
CASE

condition
aggregate

summary
wide

columnar

Next lesson: Pivot with CASE

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies