select * from table1 union select * from table2

There is a table1 with records (1,2,3,4,5,6) and table2
with records (4,5,6,7,8,9).write a query so as to get the
result as 1,2,3,4,5,6,7,8,9

Question Posted / amit

Answer Posted / amit

select * from table1
union
select * from table2

Is This Answer Correct ?

21 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What is explicit mode in sql server?

1015

What according to you is the difference between mysql and sql server performance?

1020

What is a collation?

1034

Ways to improve the performance of a SQL Azure Database?

123

What are indexers?

1032

Explain alternate key, candidate key and composite key in sql server?

859

What are alternate keys?

929

What is blocking and how would you troubleshoot it? : sql server database administration

990

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

932

Does sql server 2016 have ssms?

910

Mention what are the different types of ssrs reports?

144

Explain differences between web edition and business edition?

119

Explain can you implement data mining in ssrs?

145

What are the steps you must follow to hide sql server instances?

928

How to reaname table name without using sp_Rename in sql server..?

935