its very easy yaar who has written this? just use union operator as in set

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 / goutam dey

Answer Posted / goutam dey

its very easy yaar who has written this?
just use union operator as in set theory in mathematics
hahaha...

Is This Answer Correct ?

1 Yes

7 No

Please Help Members By Posting Answers For Below Questions

Tell about MOM Tool(Microsoft Operator Manager)?

1873

List out the differences between global and local temp tables in sql server?

1015

How to create a testing table with test data in ms sql server?

1040

What is field with example?

886

what are the different types of replication you can set up in sql server? : Sql server database administration

993

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

853

What is the stored procedure?

969

Explain transaction isolation levels in sql server?

1063

what changed between the previous version of sql server and the current version? : Sql server database administration

968

What is the minimum recommended amount of ram for sql server 2012 enterprise?

906

Do you know what is bit data type and whats the information that can be stored inside a bit column?

925

What are alternate keys?

953

Explain what is the main purpose of having conversation group?

896

How do you use a subquery to find records that exist in one table and do not exist in another?

1007

What is unpivot?

981