# Calculated Column

*noun*

say it: **“KAL-kyuh-lay-tid KOL-um”** **/ˈkælkjəleɪtɪd ˈkɒləm/**

A column in a query's result that SQL works out from each row's values instead of reading it from the table.

## What is **Calculated Column** in SQL?

**Calculated Column** — A column in a query's result that isn't stored in the table: SQL works it out from each row's values. Give it a name with `AS` so it has a heading.

```sql
SELECT ProductName,
       UnitPrice * UnitsInStock AS StockValue
FROM Products;
```

## In a sentence

- “I added a **calculated column**, UnitPrice \* UnitsInStock AS StockValue, to the report.”

Level: Apprentice · [More SQL terms at this level](https://www.ask-codey.com/glossary?category=sql&level=2)

Updated: October 28, 2026

Source: https://www.ask-codey.com/glossary/calculated-column-sql