HansenOlaTimoteivn 10SandnesSvendsonToveBorgvn 23SandnesPettersenKariStorgt 20Stavanger

SQL:

SELECT LastName AS Family, FirstName AS NameFROM Persons

结果：

HansenOlaSvendsonTovePettersenKari

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

表(Persons):

HansenOlaTimoteivn 10SandnesSvendsonToveBorgvn 23SandnesPettersenKariStorgt 20Stavanger

SQL:

SELECT LastName, FirstName FROM Persons AS Employees

结果：

表 Employees:

HansenOlaSvendsonTovePettersenKari

---

Head photo Go homepage Upload pictures Write articles	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	Family	Name	LastName	FirstName	Address	City	LastName	FirstName