Functions Aggregate

Learn how to use SQL aggregate functions to calculate sum, average, ranking, count, etc.

Title Author Date
SQL in 30 – Aggregate Functions MSSQL Tips2026-06-17
Calculate Rolling Average with SQL DATE_BUCKET Function Koen Verbeeck2026-05-10
When to use DENSE_RANK instead of SQL RANK Jared Westover2026-02-12
Controlling SQL Window Functions with Framing Jared Westover2025-12-01
SQL Partition By Examples for Aggregating Data Burt King2025-10-01
SQL Rank Functions – ROW_NUMBER, RANK, DENSE_RANK, NTILE Jared Westover2025-05-26
Tackling the Gaps and Islands Problem with T-SQL Window Functions MSSQL Tips2024-12-19
Calculate a Moving Average with T-SQL Windowing Functions Jared Westover2024-11-13
SQL COUNT DISTINCT and SQL COUNT Examples in SQL Server Eric Blinn2022-11-22
SELECT COUNT FROM SQL Server Examples and Statistics Jared Westover2022-11-16
DENSE_RANK SQL Server Function for Nth Highest Record Harris Amjad2022-09-28
SQL COUNT and SQL COUNT_BIG Functions Manvendra Singh2022-07-13
Find MAX value from multiple columns in a SQL Server table Sergey Gigoyan2021-12-08
SQL COUNT Code Examples Aubrey Love2021-10-25
SQL Server Window Functions Examples Koen Verbeeck2018-05-31
SQL Server Window Function Syntax Koen Verbeeck2018-05-31
SQL Server Window Aggregate Functions SUM, MIN, MAX and AVG Koen Verbeeck2018-05-31
SQL Server Window Functions ROW_NUMBER Koen Verbeeck2018-05-31
SQL Server Window Functions RANK, DENSE_RANK and NTILE Koen Verbeeck2018-05-31
SQL Server Window Functions LEAD and LAG Koen Verbeeck2018-05-31
SQL Statistical Window Functions PERCENTILE_DISC and PERCENTILE_CONT Koen Verbeeck2018-05-31
SQL Server Window Functions Performance Improvement Koen Verbeeck2018-05-31
SQL Server Window Functions Gaps and Islands Problem Koen Verbeeck2018-05-31
SQL Server T-SQL Window Functions Tutorial Koen Verbeeck2018-05-31
SQL Server COUNT() Function Performance Comparison Simon Liew2016-09-19
Count of rows with the SQL Server COUNT Function Tim Wiseman2016-07-07
Summarize Metrics with SQL Server T-SQL Code Tim Smith2016-05-24
SQL Server Min Max Column Normalization for Data Mining Dallas Snider2014-12-23