SQL Alias 别名

SQL 别名(Alias)是用于组织输出，使得它更易读和更有含义。SQL别名(Alias)可以用于表名，也可以用于列名。

SELECT T.Column1 AS c1, T.Column2 AS c2, T.Column3 AS c3, ...
FROM TABLE1
AS T

数据表： Employees

EmployeeId	FirstName	LastName	Department	Salary
203	Marfg	Fxun	Finance	78000
204	Joznk	Llnyo	Finance	45800
205	Hasuu	Kynuoo	Finance	57000
206	Jkucc	Qihha	Finance	62000
302	Biee	Uioooi	Development	75000
303	Kmoao	Astuu	Development	55000
304	Pissue	Koooi	Development	49000

选择所有职员(Employee)的人数：

SELECT COUNT(E.EmployeeId) AS totalEmployees
FROM Employees AS E

结果会类似于：

totalEmployees
7

Medical Tourism Destinations says:

2010年10月25日星期一 at 07:00上午

The tutorial for Sql Alias is honestly good. The functions seems to be useful in a situation when you want to organize the output. Isn’t it work as Vlookup in excel?
seychelles self catering holiday says:

2010年10月28日星期四 at 09:46上午

Alias is useful only if you’re dealing with complex queries involving multiple tables; specially if you run the risk of 2 different tables having the same or similar field names.
Massimo Bizzarro says:

2011年01月14日星期五 at 05:56下午

I need to do something like:

Set AliasName for dbo.RealName

so sql query like
select * from AliasName.dbo.MyTable
will work

I think many people need to do it

Thank you
Massimo Bizzarro
wypromowac ksiazke says:

2011年05月19日星期四 at 07:14上午

I think it is the best website about sql. I am creating MySql database on my website and every tutorial from that page helps me a lot.