select * from table1 union select * from table2 -- Union will give dis

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

Answer Posted / john

select * from table1
union
select * from table2

-- Union will give distinct value of both tables

Is This Answer Correct ?

38 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is difference between line feed ( ) and carriage return ( )?

852

What is report server project?

133

How can we delete a table in sql server?

921

What do you mean by an execution plan? Why is it used?

952

What is the difference between locking and multi-versioning?

937

Explain log shipping?

954

Give the query of getting last two records from the table in SQL SERVER?

899

How do you delete a data source?

951

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

975

How to add code to the existing article (using improve article)?

1042

Explain the concepts and capabilities of sql server?

922

How do I find the port number for sql server?

919

What is difference between cte and view?

854

How do I get to sql server configuration manager?

951

List types of tables in SQL Azure?

126