SQL Alias

SQL Alias is used to organize the output, to make it easy to read and more meaningful. SQL Alias can be used with database tables or database table columns.

SQL Alias Syntax

SELECT T.Column1 AS c1, T.Column2 AS c2, T.Column3 AS c3, ...
FROM TABLE1
AS T

SQL Alias Example

Table: Employees

Select the total number of employees:

SELECT COUNT(E.EmployeeId) AS totalEmployees
FROM Employees AS E

The result will look like: