Ravindra BagaleCourses & study guides Track your progress

29. Excel युजर्ससाठी SQL (Term Map + Side-by-Side)

29.2 GROUP BY = PivotTable / GROUPBY

By Last updated:

का (Why). PivotTable रो/कॉलम/values ≈ GROUP BY + aggregates.

काय (What). Rows वर city, Values वर Sum amount → GROUP BY city, SUM(amount).

कसं (How). शहरनिहाय विक्रीसाठी SQL pivot जुळव.

पायऱ्या

  1. Pivot चित्रित करा.
  2. GROUP BY लिहा.
  3. CSV export केल्यावर Excel totals जुळवा.

उदाहरणे

उदाहरण 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

citysales_inr
Pune9170.0
Mumbai2490.0
Kolhapur2410.0
Nashik2320.0
Goa1600.0
Solapur730.0

Meaning. SQL मधील Pivot जुळव.

Ravindra Bagale's Tip

Excel GROUPBY function (newer Excel) is even closer to SQL GROUP BY wording.