For Oracle it would be select * from table1 union all select * from

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

12 Answers
18142 Views
RBS, I also Faced
E-Mail Answers

Answer Posted / naveen

For Oracle it would be

select * from table1
union all
select * from table2

if you will use

select * from table1
union
select * from table2

it will give you double rows those are common in both the
tables.

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

1034

What is logon trigger?

1163

What is a group function explain with an example?

1040

What is the osql utility?

1039

What is SQL Azure Data sync?

123

What is onf in normalization form?

1111

Does partitioning help performance?

997

How to edit table in sql server 2017?

982

What is the difference between lock, block and deadlock? : sql server database administration

1094

Why do you need a sql server?

1173

What is the ‘fillfactor’?

1016

What do you understand by a stored procedure?

1154

Can an entity have two primary keys?

1031

How to use copy and concatenate commands in SQL?

1203

can we have a nested transaction? : Sql server database administration

1195