SQL数据库高级教程：学习 SQL Alias（别名）_[SQL Server教程]
通过使用SQL，别名（Alias）可用于列名称和表名称。
列名别名
语法：
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
