SQL Alias is used to organize the output, to make it easy to read and more meaningful. SQL Alias can be used with database tables or database table columns.
SQL Alias Syntax
SELECT T.Column1 AS c1, T.Column2 AS c2, T.Column3 AS c3, ... FROM TABLE1 AS T
SQL Alias Example
Table: 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 |
Select the total number of employees:
SELECT COUNT(E.EmployeeId) AS totalEmployees FROM Employees AS E
The result will look like:
| totalEmployees |
|---|
| 7 |
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?
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.
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
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.