select * from table1 union select * from table2

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

Answer Posted / anil

select * from table1

union

select * from table2

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Define Unique Key?

586

List the types of recovery model available in sql server?

496

How to get a list of columns using the "sys.columns" view in ms sql server?

546

What is sql sandbox in sql server?

606

If a table does not have a unique index, can a cursor be opened on it?

510

How do I partition a table in sql server?

525

What is mscorsvw.exe - process - microsoft .net framework ngen?

518

What is the benefit of normalization?

579

What do you do in data exploration

552

What is the difference between Triggers and Stored Procedure?

558

How to connect php with different port numbers?

544

How do you trace the traffic hitting a sql server?

603

What is exclusive locks?

527

What stored by the master?

530

Why use sub query in sql server and list out types of sub queries?

529