With SQL, aliases can be used for column names and table names.
通过SQL语句,可以将返回结果的栏目名或是表名重命名
Column Name Alias
栏目名转换
语法:
SELECT column AS column_alias FROM table |
Table Name Alias
表格名转换
语法:
SELECT column FROM table AS table_alias |
Example: Using a Column Alias
举例:使用栏目转换
Person数据表:
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 |
返回的结果为:
Family | Name |
---|---|
Hansen | Ola |
Svendson | Tove |
Pettersen | Kari |
Example: Using a Table Alias
举例:使用表名转换
Person数据表:
LastName | FirstName | Address | City |
---|---|---|---|
Hansen | Ola | Timoteivn 10 | Sandnes |
Svendson | Tove | Borgvn 23 | Sandnes |
Pettersen | Kari | Storgt 20 | Stavanger |
SQL语句:
SELECT LastName, FirstName |
返回的结果为:
表名换成了Employees:
LastName | FirstName |
---|---|
Hansen | Ola |
Svendson | Tove |
Pettersen | Kari |