Why do we use GROUP BY?
1Times asked
May 2026Last seen
May 2026First seen
💡 Model Answer
GROUP BY is used to aggregate rows that share a common value in one or more columns. It allows you to compute summary statistics—such as totals, averages, or counts—for each group. For example, to find the total sales per region, you would GROUP BY the region column and use SUM(sales). GROUP BY is essential when you need to transform detailed data into summarized insights, enabling efficient reporting and analysis.
This answer was generated by AI for study purposes. Use it as a starting point — personalize it with your own experience.
🎤 Get questions like this answered in real-time
Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers — invisible to screen sharing.
Get Assisting AI — Starts at ₹500