Alias 实例: 使用一个列名别名
表 Persons:
Id LastName FirstName Address City
1 Adams John Oxford Street London
2 Bush George Fifth Avenue New York
3 Carter Thomas Changan Street Beijing
SQL:
SELECT LastName AS Family, FirstName AS Name
FROM Persons
结果:
Family Name
Adams John
Bush George
Carter Thomas