Pivot with CASE

Pivot using CASE and aggregates.

Pivot with CASE

You pivot with CASE and SUM. Each category becomes a column.

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;

Two columns for two categories.

SUM(CASE WHEN category = 'Kitap' THEN amount ELSE 0 END) … is selected from sales.

Pivot with CASE — details

CASE produces values per category, SUM aggregates them. Each category is a separate column.

Writing ELSE 0 for non-matching rows matters; without ELSE the CASE returns NULL, and while SUM still works, functions like COUNT can give wrong results.

Exercise Pivot with CASE

Produce a Book column with SUM(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

Add SUM

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

Show answer

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

What is summed in a CASE pivot?
- The CASE result
- All rows
- An index
- The column name
Show answer

The CASE result — The CASE result is summed with SUM.
Pivot with CASE: match the terms

CASE

condition
SUM

sum
category

column
pivot

convert

Next lesson: FILTER clause

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies