'Alias' is used rename a column making it more readable or shortened as per the requirements. The alias name is
displayed in the column header instead of the original name.
The Alias Name
The 'ALIAS ' name helps you to rename a column from its original name temporarily ie. only the display header of that column's name is
changed temporarily to the given alias name.
SQL Alias name Syntax
Select column-3 as Col3 ,column-1 as Col1,column-2 as Col2,... column-n
from table
The Alias name Example
The 'Employees' tables contains their respective data as shown
below.
1 |
Richard Hughes |
4/23/1945 12:00:00 AM |
1 |
1 |
New Orleans |
950.00 |
2 |
Taryn Sinclair |
3/22/1980 12:00:00 AM |
2 |
2 |
San Francisco |
800.00 |
3 |
Ted Horowitz |
3/31/1960 12:00:00 AM |
3 |
4 |
New York |
700.00 |
4 |
Jonathan Douglas |
7/7/1971 12:00:00 AM |
3 |
4 |
Salt Lake City |
600.00 |
5 |
Miranda Leigh |
7/19/1983 12:00:00 AM |
7 |
3 |
New York |
500.00 |
6 |
Jana Rae |
9/23/1976 12:00:00 AM |
8 |
2 |
Houston |
400.00 |
7 |
Lita Rosanna |
9/14/1982 12:00:00 AM |
4 |
6 |
Long Island |
650.00 |
8 |
Colin Flooks |
12/29/1988 12:00:00 AM |
4 |
2 |
Salt Lake City |
600.00 |
9 |
Anthony Frank |
2/22/1988 12:00:00 AM |
9 |
3 |
San Francisco |
750.00 |
10 |
Stephanie Lynn |
7/30/1979 12:00:00 AM |
8 |
2 |
Salt Lake City |
450.00 |
11 |
Jack Martin |
8/25/1985 12:00:00 AM |
NULL |
NULL |
Austin |
500.00 |
Select EmployeeID,EmployeeName,DateOfBirth as DOB,DesignationID,DeptID,City,Salary
from Employees
Note : You can also use the ALIAS name for a table in the same manner to rename it temporarily.
SQL 'ALIAS' table name Syntax
Select column-3,column-1,column-2,... column-n
from table2 as Alias_Name
where condition