SQL guide-alias

Using SQL, you can use aliases for the list and table names.

--------------------------------------------

Column alias

Syntax:

SELECT column AS column_alias FROM table

--------------------------------------------

Table alias:

Syntax:

SELECT column FROM table AS table_alias

--------------------------------------------

Syntax: Use the column alias for 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 statement:

SELECT LastName AS Family, FirstName AS Name FROM Persons

Return this result:

Family	Name
Hansen	OLA
Svendson	Tove
Pettersen	Kari

--------------------------------------------

Example: use the 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 statement:

SELECT LastName, FirstName FROM Persons AS Employees

Return this result:

Employees table:

Lastname	Firstname
Hansen	OLA
Svendson	Tove
Pettersen	Kari