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
- 12 Answers
- 15943 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
When multiple after triggers are attached to sql table, how to control the order of execution?
What are the default system databases in sql server 2000?
How can you append an identity column to a temporary table?
How can we improve performance by using SQL Server profiler?
What is the purpose of grouping data in a report?
How to encrypt data between dialogs?
1 01 101 01010
How does index makes search faster?
What is explicit cursors?
What are temporal tables in sql server 2016?
Explain what is scheduled job and how to create it?
Can you explain the disadvantages/limitation of the cursor?
Do you know what is sql injection?
Can two tables share the same primary key?
What is the default value of an integer data type in sql server 2005?
