Skip to content
  • Home
  • About
  • No Access
  • Privacy Policy
Bits of .NET
Bits of .NET
  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy

Bits of .NET

Daily micro-tips for C#, SQL, performance, and scalable backend engineering.

  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy
SQL

SQL: Use GROUP BY to Aggregate Data

- 20.06.26 - ErcanOPAK

📊 GROUP BY = Summarize Your Data

Need totals, averages, counts? GROUP BY aggregates data. Sales by category, users by country, orders by month.

📝 Basic GROUP BY

-- Count per category
SELECT category, COUNT(*) as product_count
FROM products
GROUP BY category;

-- Average price per category
SELECT category, AVG(price) as avg_price
FROM products
GROUP BY category;

-- Total sales per customer
SELECT customer_id, SUM(total) as total_spent
FROM orders
GROUP BY customer_id;

-- Orders per month
SELECT 
    DATE_TRUNC('month', order_date) as month,
    COUNT(*) as order_count,
    SUM(total) as total_revenue
FROM orders
GROUP BY DATE_TRUNC('month', order_date)
ORDER BY month DESC;

🎯 Advanced GROUP BY

-- Multiple columns
SELECT 
    category,
    status,
    COUNT(*) as count,
    AVG(price) as avg_price
FROM products
GROUP BY category, status;

-- With HAVING (filter groups)
SELECT 
    category,
    COUNT(*) as product_count
FROM products
GROUP BY category
HAVING COUNT(*) > 5;

-- With ROLLUP (subtotals)
SELECT 
    category,
    SUM(price) as total
FROM products
GROUP BY ROLLUP(category);

-- With CUBE (all combinations)
SELECT 
    category,
    status,
    COUNT(*) as count
FROM products
GROUP BY CUBE(category, status);

💡 Common Aggregations

  • COUNT(): Number of rows
  • SUM(): Sum of values
  • AVG(): Average value
  • MIN(): Minimum value
  • MAX(): Maximum value
  • COUNT(DISTINCT): Unique values

“Need sales by category. GROUP BY + SUM did it. One query, instant report. GROUP BY is essential for analytics.”

— Data Analyst

Related posts:

SQL Server: Why a GUID Primary Key Fragments a Table Far Faster Than an Identity Column Ever Would

SQL Server: Why a GUID Primary Key Fragments a Table Far Faster Than an Identity Column Ever Would

Add Default Value in SQL Server

Add Default Value in SQL Server

SQL: Use CTEs for Readable Complex Queries

SQL: Use CTEs for Readable Complex Queries

Views: 11

Post navigation

.NET Core: Use appsettings.json for Configuration
C#: Use Namespaces to Organize Your Code

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

November 2026
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
30  
« Oct    

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,055)
  • Get the User Name and Domain Name from an Email Address in SQL (980)
  • How to add default value for Entity Framework migrations for DateTime and Bool (976)
  • Get the First and Last Word from a String or Sentence in SQL (857)
  • How to select distinct rows in a datatable in C# (852)
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server (653)
  • Add Constraint to SQL Table to ensure email contains @ (607)
  • Average of all values in a column that are not zero in SQL (569)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (546)
  • Find numbers with more than two decimal places in SQL (475)

Recent Posts

  • C#: Fix a ConditionalWeakTable Entry Vanishing Too Soon
  • Docker: Fix a Stale COPY Layer After Editing .dockerignore
  • Photoshop: Fix a Pattern Overlay Scaling Wrong on a High-DPI File
  • SQL Server: Fix a Computed Column Index Skipped by Implicit Cast
  • HTML5: Fix a required Input Inside a Hidden Tab Blocking Submit
  • SQL Server: Fix ROW_NUMBER Ties Reordering Between Identical Runs
  • C#: Fix an Enum HasFlag Returning True for the Zero Value
  • WordPress: Fix Featured Images Vanishing After a CDN Migration
  • Photoshop: Fix Content-Aware Fill Smearing a Repeating Pattern
  • Asp.Net Core: Fix Antiforgery Tokens Rejected Behind a Reverse Proxy

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,055)
  • Get the User Name and Domain Name from an Email Address in SQL (980)
  • How to add default value for Entity Framework migrations for DateTime and Bool (976)
  • Get the First and Last Word from a String or Sentence in SQL (857)
  • How to select distinct rows in a datatable in C# (852)

Recent Posts

  • C#: Fix a ConditionalWeakTable Entry Vanishing Too Soon
  • Docker: Fix a Stale COPY Layer After Editing .dockerignore
  • Photoshop: Fix a Pattern Overlay Scaling Wrong on a High-DPI File
  • SQL Server: Fix a Computed Column Index Skipped by Implicit Cast
  • HTML5: Fix a required Input Inside a Hidden Tab Blocking Submit

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter
© 2026 Bits of .NET | Built with Xblog Plus free WordPress theme by wpthemespace.com