SQL ALIAS Statement

by

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

 
Next Topic: SQL WHERE Clause with example.
Previous Topic: SQL NOT BETWEEN Operator with example.