SELECT column AS column_alias FROM table

SELECT column FROM table AS table_alias

实例: 使用一个列名别名

表(Persons):

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

SQL:

SELECT LastName AS Family, FirstName AS Name
FROM Persons

结果：

Family
Name
Hansen
Ola
Svendson
Tove
Pettersen
Kari

实例: 使用一个表名称别名

表(Persons):

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

SQL:

SELECT LastName, FirstName FROM Persons AS Employees

结果：

表 Employees:

LastName
FirstName
Hansen
Ola
Svendson
Tove
Pettersen
Kari