CodesJava

Easy learning with example program codes

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:
error
Posted in SQL   








Copyright © 2019 CodesJava DMCA.com Protection Status