12.1 GROUP BY म्हणजे SQL चा PivotTable

By Ravindra Bagale Last updated: 31 October 2026

का (Why). Excel युजर्सना PivotTables माहीत — SQL मध्ये ती कल्पना GROUP BY.

काय (What). GROUP BY मूल्यांच्या प्रत्येक ग्रुपसाठी एक आउटपुट रो बनवतो.

कसं (How). SELECT city, SUM(amount_inr) FROM orders GROUP BY city;

पायऱ्या

उदाहरण 1 · dataset: raja_coffee

SELECT city, ROUND(SUM(amount_inr),2) AS sales_inr
FROM orders
GROUP BY city
ORDER BY sales_inr DESC;

Output

Meaning. Pivot सारखे: शहर रो, विक्री बेरीज.

Ravindra Bagale's Tip

See also /guides/excel-vs-sql.html for the Excel term map.