What is the purpose of column alias?

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;