Column Alias

noun

say it: “KOL-um AY-lee-us” /ˈkɒləm ˈeɪliəs/

A temporary name given to a column or calculated value in a query's results, written with AS.

What is Column Alias in a relational database?

Column Alias — A temporary output name assigned to a selected expression or column.

SELECT total_amount AS order_total
FROM purchase_order;

In a sentence

  • “I gave the total a column alias, AS StockValue, so the result has a clear heading.”

Level: Novice · More SQL terms at this level

Updated