SQL Server Transact Basic to Expert - Select Query with Column Alias

This blog shows how to use the column alias with in the select query. Column Alias is to provide soem unique name for the result set to indicate the user for further usage.

Syntax:

Select Column1 as 'AliasName', Column2 as 'Aliasname1'
From table

Example:

Select empName as 'Employee Name', empId as 'Employee Salary'