Column Alias in SQL
In SQL, Column aliases are used to make column headings in your result which make it easier to read. Simply, say that a column alias is used to give a temporary name of the column in a table.
Important Points of Aliases
- Alias is created with the AS keyword, for more understanding see the syntax example.
- Aliases are used to give a temporary name to a table or a column in a table which makes the column names more readable.
- An alias only exists for the duration of that query.
Syntax of Column Alias
SELECT column_name AS alias_name
FROM table_name;