MySQL + SQL · Lesson 1

Pivot Table Mysql

What is a Pivot?

A pivot turns row values into columns — for example, showing monthly sales as separate columns. MySQL does this with CASE + SUM.

Pivot with CASE

SELECT product,
  SUM(CASE WHEN month = 'Jan' THEN amount ELSE 0 END) AS Jan,
  SUM(CASE WHEN month = 'Feb' THEN amount ELSE 0 END) AS Feb
FROM sales
GROUP BY product;
product Jan Feb ------- ---- ---- Pen 100 150

Summary

  • MySQL has no PIVOT keyword — use SUM(CASE WHEN ... THEN ... END).
  • Each CASE becomes one new column; GROUP BY the row label.
🔗

Share this topic with a friend

यह topic किसी दोस्त को भेजें

Found it useful? Send it to a classmate learning the same thing.

अच्छा लगा? जो दोस्त यही सीख रहा है, उसे भेज दीजिए।

💻 Live Code Editor

This page's programs are ready here — run them, edit them, and learn. No installation needed.
Powered by OneCompiler. The code loads into the editor automatically — press Run to see the output. If the editor does not open, open it in a new tab.