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

What is the difference between local and global temporary tables?

1126

How many non clustered indexes there can be on table ?

894

What is filter index?

935

What do you need to connect php to sql server?

1087

What is postgresql server?

976

What is catalog views?

1057

What is row_number function?

979

What type of Index will get created after executing the above statement?

1077

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

2043

Can sql server be linked with other servers like oracle?

945

What do you understand by mirroring and mention the advantages of the mirroring?

1046

Explain syntax for viewing trigger?

904

What are the advantages of passing name-value pairs as parameters?

1151

What happens if ntwdblib.dll is missing on your machine?

1129

How to replace null values in expressions using isnull()?

1080