SQL Alias

With SQL, aliases can be used for column names and table names.

---

Column Name Alias

The syntax is:

SELECT column AS column_alias FROM table

---

Table Name Alias

The syntax is:

SELECT column FROM table AS table_alias

---

Example: Using a Column Alias

This table (Persons):

LastName	FirstName	Address	City
Hansen	Ola	Timoteivn 10	Sandnes
Svendson	Tove	Borgvn 23	Sandnes
Pettersen	Kari	Storgt 20	Stavanger

And this SQL:

SELECT LastName AS Family, FirstName AS Name FROM Persons

Returns this result:

Family	Name
Hansen	Ola
Svendson	Tove
Pettersen	Kari

---

Example: Using a Table Alias

This table (Persons):

LastName	FirstName	Address	City
Hansen	Ola	Timoteivn 10	Sandnes
Svendson	Tove	Borgvn 23	Sandnes
Pettersen	Kari	Storgt 20	Stavanger

And this SQL:

SELECT LastName, FirstName FROM Persons AS Employees

Returns this result:

Table Employees:

LastName	FirstName
Hansen	Ola
Svendson	Tove
Pettersen	Kari