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

can you implement data mining in SSRS?

148

Which table keeps the locking information?

922

What is faster join or union?

1210

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1942

What happens if the update subquery returns multiple rows in ms sql server?

1125

What is history table in sql server?

971

What is normalization process?

1175

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

1038

What is row-level compre?

997

What are synonyms?

960

How to create an index on a view?

1069

Explain the properties of sub-query in sql server?

1016

How to create function with parameter in sql server?

1105

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

1198

what is difference between NULL and ISNULL in SQL Server 2008?

1014