Alias in SQL

The ALIAS statement is used to temporarily rename a table or column in a SQL statement.

Syntax:

 SELECT columnName AS columnAliasName FROM tableName As tableAliasName;

Example:

SELECT EMP_NAME AS NAME FROM EMPLOYEE WHERE EMP_ID = 1;

Output:

NAME
Parbhjot