Pivot Table Mysql

What is a Pivot?

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;

Summary

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

Pivot क्या है?

CASE से Pivot

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;

सारांश

• MySQL में PIVOT keyword नहीं — SUM(CASE WHEN ... THEN ... END) use करें।
• हर CASE एक नया column बनता है; row label पर GROUP BY करें।