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 the cartesian product of the table?

915

What is sql sandbox in sql server?

1160

How to create view in stored procedure sql server?

970

How to list all field names in the result set using mssql_field_name()?

874

What are different types of data sources?

954

How to create median function?

158

What’s the use of custom fields in report?

901

Do you know the policy based administration feature of sql server 2008?

917

User wants only to display only pdf as export option in report manager. How to achieve this?

253

Explain the disadvantages/limitation of the cursor?

923

What is acid properties?

1034

Explain sql server service broker?

941

What are the encryption mechanisms in sql server?

979

How to connect to a sql server using odbc_connect()?

1108

How to get the number of affected rows?

964