Answer:
let’s us assume that we have the following table of Employee.
Emp_Id |
Emp_Name |
Emp_Salary_2010 |
Emp_Salary_2011 |
1 |
Shiv |
17000 |
19000 |
2 |
Raju |
13500 |
15000 |
3 |
Sham |
15000 |
18000 |
4 |
Moosa |
11000 |
14000 |
5 |
Feroz |
12000 |
16000 |
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 Employee
union
select Emp_Name,Emp_Salary_2011 as Salary from Employee
Output:-
Emp_Name |
Salary |
Shiv |
17000 |
Shiv |
19000 |
Raju |
13500 |
Raju |
15000 |
Sham |
15000 |
Sham |
18000 |
Moosa |
11000 |
Moosa |
14000 |
Feroz |
12000 |
Feroz |
15000 |
Please click here to see more .NET and SQL Server interview questions
Regards,
About C#.NET, ASP.NET MVC Core, Angular, Azure, (MSBI)Business Intelligence, Data Science - Python Interview Questions
This blog is for developers who want to crack .NET and C# interviews. It has all tips and tricks needed to crack .NET interviews , C# interview , SQL Server interview , Java interview , WCF Interview , Silverlight interview , WPF interview , LINQ interview , Entity framework Interview.
Do not forget to watch our Learn step by step video series.
ASP.NET MVC Interview Questions and Answers:- https://youtu.be/pXmMdmJUC0g
C# Interview Questions and Answers:- https://youtu.be/BKynEBPqiIM
Angular Interview Questions and Answers:- https://youtu.be/-jeoyDJDsSM
C# tutorial for beginners(4 hrs.):- https://youtu.be/AxEGRBFwlmI
Learn Azure Step by Step:- https://youtu.be/wdUK7bCMXqs
Azure AZ-900 fundamentals certification :- https://youtu.be/hC9iGgJorz8
AZ- 204 certification Azure:- https://youtu.be/qI8PRn2C080
Learn Angular tutorial step by step https://tinyurl.com/ycd9j895
Learn MVC 5 step by step in 16 hours:- https://youtu.be/Lp7nSImO5vk
Learn Design Pattern Step by Step https://goo.gl/eJdn0m
Learn MSBI Step by Step in 32 hours:- https://goo.gl/TTpFZN
Learn SQL Server Step by Step http://tinyurl.com/ja4zmwu
Python Tutorial for Beginners:- https://youtu.be/KjJ7WzEL-es
Learn Data Science in 1 hour :- https://tinyurl.com/y5o7qbau
Learn Power BI Step by Step:- https://tinyurl.com/y6thhkxw
Learn Tableau step by step :- https://tinyurl.com/kh6ojyo