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