SQL Aliases used to assign the temporary names to table OR column name in a table.

• Aliases reduce the amount of typing required to enter a query.
• Alias only exists for the duration of the query.

Alias Table Syntax

SELECT  column_name(s)
FROM table_name
AS alias_name
WHERE [condition];

Alias Column Syntax

SELECT  column_name AS alias_name
FROM table_name
WHERE [condition];

EXAMPLE: SQL Aliases

Student Table

A table of student records, the name of table is "Student", and the name of columns are [ROLL_NO, STUDENT_NAME, ADDRESS, MOBILE_NO, AGE, and BRANCH]:

Alias for Column Example

SELECT  STUDENT_NAME AS S_NAME, BRANCH AS STUDENT_BRANCH
FROM Student;

Result Lokk Like

If you want space between the Alias Name contains then double quotation marks or square brackets required, write alias Column Name Between:

Alias for Column Example

SELECT  STUDENT_NAME AS S_NAME, BRANCH AS [STUDENT BRANCH]
FROM Student;

Result Lokk Like

EXAMPLE: Alias for Tables

Customers Table

Simple Customers record table & the name of the table is CUSTOMERS. The Column(s) name of the table like [ID, NAME, EMAIL, ADDRESS, and SALARY]:

Orders Table

This is a sample ORDER table; The columns of the table are [OID, DATE, CUSTOMER_ID, and AMOUNT]:

The table aliases are used to rename a table in a specific SQL statement to make it easier to read.

Alias for Tables Example

SELECT  C.ID, C.NAME, C.EMAIL, O.AMOUNT
FROM CUSTOMERS AS C, ORDERS AS O
WHERE C.ID = O.CUSTOMER_ID;

Result Lokk Like