Unpivot

Turn columns into rows.

Unpivot

Unpivot turns columns into rows. It converts a wide table to a narrow format.

SELECT 'Kitap' AS category, kitap AS amount FROM monthly
UNION ALL
SELECT 'Elektronik', elektronik FROM monthly;

This query converts two columns into two rows.

'Kitap' AS category, kitap AS amount is selected from monthly.

Unpivot — details

Unpivot is done with UNION ALL. Each column becomes a separate SELECT.

For example, you turn the books and electronics columns into rows with two columns, category name and amount; this shape suits charts and grouping better.

Exercise Unpivot

Turn kitap and elektronik columns into rows with UNION ALL.

Show example solution

SELECT 'Kitap' AS category, kitap AS amount FROM monthly
UNION ALL
SELECT 'Elektronik', elektronik FROM monthly;

Test yourself

What does unpivot turn into rows?
- Rows
- Indexes
- Columns
- Triggers
Show answer

Columns — Unpivot turns columns into rows.

Add UNION ALL

SELECT 'Kitap' AS category, kitap AS amount FROM monthly
____
SELECT 'Elektronik', elektronik FROM monthly;

Show answer

SELECT 'Kitap' AS category, kitap AS amount FROM monthly
UNION ALL
SELECT 'Elektronik', elektronik FROM monthly;

Unpivot: match the terms

unpivot

column→row
UNION ALL

combine
narrow

few columns
wide

many columns

Next lesson: Dynamic pivot

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies