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 query and subquery?

602

Define inner join? Explain with an example?

498

Write a sql query to sort on different column name according to the parameters passed in the function?

516

What is the use of RDBMS?

573

What is subreport?

What is the difference between varchar and nvarchar datatypes?

559

What is merge replication?

696

Explain what is scheduled job and how to create it?

536

Define right outer join?

534

What is faster join or union?

586

How do database indexes work?

534

What kind of problems occurs if we do not implement proper locking strategy?

949

Why use “pivot” in sql server?

612

What is page in sql server?

501

List the ways in which dynamic sql can be executed?

625