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

Why use update_statistics command in sql server?

1113

Define Business Edition in SQL Azure?

102

Define model database?

1032

What are the dmvs?

1074

Do you have any idea about the tcl commands?

1016

Write a code to select distinct records without using the DISTINCT keyword.

1186

What is the name of reporting services config file and what’s it’s used for?

153

How can we solve concurrency problems?

1098

How to skip remaining statements in a loop block using continue statements?

1043

How sql server executes a statement with nested subqueries?

1094

How can you tell if a database object is invalid?

1118

What are distributed partitioned views?

1137

Explain full-text query in sql server?

1054

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

1025

What is index, cluster index and nonclustered index?

1049