Column Alias

Defining :

• Rename the column heading and useful with calculations.
• Must be put double quotation marks if it contains spaces or special characters or is case sensitive.

Example:

SELECT name AS  emp_name, comm commission FROM dept;
SELECT name "Name", salary*12 "Annual Salary" FROM dept;