Tutorial Gateway

SQL ALIAS

by

The SQL ALIAS is used to temporarily rename the table names and column headings.

In SQL Server, sometimes column names will not be user-friendly. For instance, we store [First Name] as either [FirstName] or [First_Name]. When we read that first name data, it was annoying to see the column heading like that. So, We use this Alias names concept, and rename them to more user-friendly (such as [First Name] or [FIRST NAME].

SQL Alias Syntax

The basic syntax to write Alias Column Names in SQL Server is as shown below:

-- SQL Server ALIAS Syntax
SELECT [Column_Name] AS [Name]
FROM [Table_Name]

--OR You can Simply Write without using AS Keyword
SELECT [Column_Name] [Name]
FROM [Table_Name]

TIP: In SQL Server Alias, AS Keyword is optional. It is up to you to include it or not.

We are going to use the below-shown data to explain the ALIAS Column Names with an example.

Alias names in sql

SQL Alias Example 1

In this example, we are going to rename the column names in the above specified table to read them easily. We are going to rename [FirstName] to [First Name], [LastName] to [Last Name], [YearlyIncome] to [Yearly Income] and [Occupation] to [Profession]

SELECT [FirstName] AS [First Name]
      ,[LastName] AS [Last Name]
      ,[YearlyIncome] AS [Yearly Income]
      ,[Education]
      ,[Occupation] AS [Profession]
  FROM [Customer]

OUTPUT

SQL ALIAS 1

SQL Alias Column Example 2

In this example, We added the [FirstName] and [LastName] column to create Full Name and we assigned [Full Name] as the Alias Name.

SELECT [FirstName] + ' ' + [LastName] AS [Full Name]
      ,[YearlyIncome] 
      ,[Education]
      ,[Occupation] 
FROM [Customer]

OUTPUT
SQL ALIAS 2

SQL Alias Example 3

We can also apply the Alias names to calculated columns (mathematical calculations). In this example, we will show you, How to apply Alias names to calculated columns

SELECT [FirstName] 
      ,[LastName] 
      ,([YearlyIncome]  + 15000) AS Income
      ,[Education]
      ,[Occupation]
  FROM [Customer]

We added 15000 to each and every record of the [YearlyIncome] column and renamed the column name as Income.

OUTPUT

SQL ALIAS 3

Thank You for Visiting Our Blog

Placed Under: SQL