Aliasing columns in a SELECT statement example


The purpose for aliasing a column is to have a friendly name for the column.  This name might differ from the physical design to business terms or remove issues such as spacing in the column name.  Let's take a look at an example. 

Let's use the same query from an earlier tutorial with one minor modification for the column alias.  In the example below, we are selecting the LoginID column from the HumanResources.Employee table where the VacationHours column equals 8 and we are ordering the data by the HireDate in ascending order which is implied.  What is different is that we are aliasing the LoginID column as 'Domain\LoginName' to be a little bit more specific.

USE AdventureWorks;
SELECT LoginID AS 'Domain\LoginName'
FROM HumanResources.Employee
WHERE VacationHours = 8
ORDER BY HireDate;

Below is the sample result set, which shows the column name returned as 'Domain\LoginName' (alias) rather than LoginID (physical design):

Last Update: 3/9/2009

Comments For This Article


get free sql tips
agree to terms

Learn more about SQL Server tools