SQL ALIAS Statement

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.

 

Please follow and like us:
Content Protection by DMCA.com