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: Data Aggregation with GROUP BY and HAVING

- 15.08.26 - ErcanOPAK

📊 Data Aggregation = Business Intelligence

Raw data is not enough. GROUP BY and HAVING aggregate data for business intelligence and reporting.

📝 Aggregation Examples

-- Basic GROUP BY
SELECT 
    category,
    COUNT(*) as product_count,
    AVG(price) as avg_price,
    SUM(stock) as total_stock,
    MIN(price) as min_price,
    MAX(price) as max_price
FROM products
GROUP BY category;

-- Multiple Columns
SELECT 
    year,
    month,
    SUM(sales) as total_sales,
    COUNT(*) as order_count
FROM orders
GROUP BY year, month
ORDER BY year DESC, month DESC;

-- HAVING Clause
SELECT 
    category,
    COUNT(*) as product_count,
    AVG(price) as avg_price
FROM products
GROUP BY category
HAVING AVG(price) > 100
AND COUNT(*) > 5
ORDER BY avg_price DESC;

-- WITH ROLLUP
SELECT 
    category,
    subcategory,
    SUM(sales) as total_sales
FROM products
GROUP BY ROLLUP(category, subcategory);

-- WITH CUBE
SELECT 
    category,
    subcategory,
    SUM(sales) as total_sales
FROM products
GROUP BY CUBE(category, subcategory);

🎯 Advanced Aggregation

-- Window Functions with Aggregation
SELECT 
    category,
    product_name,
    price,
    AVG(price) OVER (PARTITION BY category) as category_avg,
    price - AVG(price) OVER (PARTITION BY category) as price_diff
FROM products;

-- Pivot Table
SELECT 
    year,
    SUM(CASE WHEN month = 1 THEN sales END) as jan,
    SUM(CASE WHEN month = 2 THEN sales END) as feb,
    SUM(CASE WHEN month = 3 THEN sales END) as mar
FROM sales
GROUP BY year;

-- Aggregate with Subquery
SELECT 
    category,
    COUNT(*) as count,
    (SELECT AVG(price) FROM products p2 WHERE p2.category = p1.category) as avg_price
FROM products p1
GROUP BY category;

-- Percentile Aggregation
SELECT 
    category,
    PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY price) as median_price,
    PERCENTILE_CONT(0.25) WITHIN GROUP (ORDER BY price) as q1_price,
    PERCENTILE_CONT(0.75) WITHIN GROUP (ORDER BY price) as q3_price
FROM products
GROUP BY category;

💡 Aggregation Tips

  • Use appropriate aggregate functions
  • Filter with HAVING instead of WHERE
  • Use window functions for running totals
  • Consider performance for large datasets
  • Use indexes on GROUP BY columns

Data aggregation transforms raw data into actionable insights. It’s the foundation of business intelligence.

— Data Analyst

Related posts:

SQL: Use COALESCE to Replace NULL Values Inline

SQL: Use COALESCE to Replace NULL Values Inline

Use EXISTS Instead of COUNT(*)

Use EXISTS Instead of COUNT(*)

SQL Server — Nonclustered Index INCLUDE Is a Superpower

SQL Server — Nonclustered Index INCLUDE Is a Superpower

Views: 16

Post navigation

.NET Core: Implementing Mediator Pattern with DI
C#: Implementing Retry Patterns with Async/Await

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,068)
  • Get the User Name and Domain Name from an Email Address in SQL (990)
  • How to add default value for Entity Framework migrations for DateTime and Bool (986)
  • Get the First and Last Word from a String or Sentence in SQL (865)
  • How to select distinct rows in a datatable in C# (859)
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server (661)
  • Add Constraint to SQL Table to ensure email contains @ (619)
  • Average of all values in a column that are not zero in SQL (577)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (553)
  • Find numbers with more than two decimal places in SQL (481)

Recent Posts

  • Network Speed Monitor Windows Application v2.5.1
  • Ağ Hızı İzleyici Windows Uygulaması v2.5.1
  • How to make theater mode the default for Youtube
  • The AI Prompt That Audits a Function for Thread-Safety Gaps
  • Ajax: Fix a Fetch Request Caching a Response Despite No-Store
  • WordPress: Fix a Navigation Block Losing Submenu Items After Sync
  • Visual Studio: Fix CodeLens Reference Counts Stuck at Stale Numbers
  • C#: Fix a UTF-8 String Literal Behaving Differently in a Switch
  • Photoshop: Fix a Liquify Mesh Snapping Back on a Smart Object
  • The AI Prompt That Turns a Crash Dump Into a Short Repro Script

Most Viewed Posts

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

Recent Posts

  • Network Speed Monitor Windows Application v2.5.1
  • Ağ Hızı İzleyici Windows Uygulaması v2.5.1
  • How to make theater mode the default for Youtube
  • The AI Prompt That Audits a Function for Thread-Safety Gaps
  • Ajax: Fix a Fetch Request Caching a Response Despite No-Store

Social

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