Ways of assigning aliases to a columns

vishalneeraj-24503
Posted by vishalneeraj-24503 under Sql Server category on | Points: 40 | Views : 299
1st way:-
Select Employee_Id As Emp_Id,
Employee_Name As Employee_Name
From Employee_Master
Order By Employee_Name

2nd way:-
Select Employee_Id Emp_Id,
Employee_Name Employee_Name
From Employee_Master
Order By Employee_Name

3d way:-
Select Employee_Id  = Emp_Id,
Employee_Name = Employee_Name
From Employee_Master
Order By Employee_Name

Comments or Responses

Login to post response