# Calculations vs Aggregations

A calculation works within one row and returns a value for every row; an aggregation works across many rows and returns one value for all of them.

![Cheat sheet: Calculations vs Aggregations](https://fsdtrainingmedia.blob.core.windows.net/public/images/2026/11/41fc611975914174bf3eb9f4376bd4cf.webp)

- Category: SQL
- Level: Apprentice
- Tags: Aggregate Function, sql, t-sql
- Updated: November 3, 2026

Source: https://www.ask-codey.com/cheat-sheets/aggregate-functions-in-t-sql-calculations-vs-aggregations-cheat-sheet