Aggregation & Grouping
GROUP BY & HAVING
Grouping Rows
💡 GROUP BY, EK, "SORTING, BIN" system, hai — rows, ko, EK, field, ke, VALUES, ke, hisaab, se, GROUPS, mein, DAALA, jaata hai, JAISE, EK, FRUIT, VENDOR, apple, orange, banana, KE, SEPARATE, BASKETS, mein, SORT, karta hai.
GROUP BY, rows, ko, EK, YA, MULTIPLE, columns, ke, hisaab, se, group, karta hai — HAR, group, ke, liye, aggregate, functions, (COUNT, SUM, AVG) calculate, kiye, ja, sakte, hain.
HAVING, GROUPS, ko, FILTER, karta hai (WHERE, ki, tarah, LEKIN, aggregated, data, PAR) — WHERE, individual, rows, ko, filter, karta hai, HAVING, groups, ko.
SELECT category, COUNT(*) AS total, AVG(price) AS avg_price
FROM products
GROUP BY category
HAVING COUNT(*) > 5;
-- Sirf, wo, categories, jinme, 5, se, zyaada, products, hain🗃️
GROUP BY, EK, "SORTING, BIN" system, hai — rows, ko, EK, field, ke, VALUES, ke, hisaab, se, GROUPS, mein, DAALA, jaata hai, JAISE, EK, FRUIT, VENDOR, apple, orange, banana, KE, SEPARATE, BASKETS, mein, SORT, karta hai.
1 / 2
⚡ Quick Recap
- GROUP BY = rows, ko, columns, ke, hisaab, se, group, karta, hai
- HAVING = groups, ko, filter, karta, hai (aggregated, data, par)
- WHERE = rows, filter, karta, hai, HAVING, se, PEHLE
Is page mein (2 subtopics)
GROUP BY, MULTIPLE, columns, le, sakta hai — jaise, GROUP BY category, region, HAR, UNIQUE, category-region, COMBINATION, ke, liye, EK, ALAG, group, banaता hai.
SELECT category, region, SUM(amount) FROM sales GROUP BY category, region;WITH ROLLUP, GROUP BY, ke, saath, use, hone, PAR, SUBTOTAL, aur, GRAND, TOTAL, rows, bhi, ADD, kar, deta hai — reporting, dashboards, ke, liye, useful, feature, hai.
Tip: WITH ROLLUP, se, generate, HUI, subtotal, rows, mein, grouped, column, ki, VALUE, NULL, hoti, hai — application, code, mein, ISE, "Total" ki, tarah, DISPLAY, kiya, ja, sakta hai.