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 / anil

Answer Posted / anil

select * from table1

union

select * from table2

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Do you know concepts and capabilities of sql server?

1060

What are locks in sql?

980

How to update values in a table with update statements in ms sql server?

1013

Why the trigger fires multiple times in single login?

1211

What are a scheduled jobs?

956

What are “phantom rows”?

1657

What are the different types of lock modes in sql server 2000?

949

Can I delete event logs?

924

Are null values the same as that of zero or a blank space?

1040

What are the aggregate and scalar functions?

1068

Explain what is the use of custom fields in report?

927

How to find the service pack installed? : sql server database administration

1023

query processing

2173

how to define testing of network layers? : Sql server database administration

972

What is an index in a database?

979