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.

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

Updated October 28, 2026