SQL Aliases: Using Aliases in SQL Queries

Syntax: Alias Column Syntax

SELECT column_name AS alias_name
FROM table_name

Syntax: Alias Table Syntax

SELECT column_name(s)
FROM table_name AS alias_name

Prerequisite Codes

If you don't have table please create below table and practice it.

My database name is SQLExamples

USE SQLExamples

Create this below Employee table

DROP TABLE Employee
CREATE TABLE Employee(
EmpId INT,
EmpName VARCHAR(25),
EmpAddress VARCHAR(100),
EmpDept VARCHAR(25)
)

Insert data inside table

INSERT INTO Employee VALUES
(1, 'Rambo', 'Kolkata', 'IT'),
(2, 'Rohit', 'Kolkata', 'IT'),
(3, 'Rohon', 'Kolkata', 'ITIS'),
(4, 'Ronok', 'Kolkata', 'ITIS'),
(5, 'Rubin', 'Kolkata', 'ITIS'),
(6, 'Sorif', 'Kolkata', 'ADMIN'),
(7, 'Soriful', 'Kolkata', 'ADMIN'),
(8, 'Sofik', 'Kolkata', 'ADMIN')

SELECT * FROM Employee

Output:

The above code will produce the following result-

Example:

Code: Alias Column Syntax

SELECT EmpAddress AS cityName
FROM Employee

Output:

The above code will produce the following result-

Example:

Code: Alias Table Syntax

SELECT EmpName
FROM Employee AS EmployeeTable

Output:

The above code will produce the following result-