let's us assume that we have the following table of Employee.
Now we want to merge the Emp_Salary_2010 and Emp_Salary_2011 columns into a single column as Salary. Query:-
select Emp_Name,Emp_Salary_2010 as Salary from EmployeeOutput:-
select Emp_Name,Emp_Salary_2011 as Salary from Employee
Asked In: Many Interviews |