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