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
- 14733 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
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
Does group by sort data?
Do you know what is lock escalation?
What sql server means?
How to insert a new row into a table with "insert into" statements in ms sql server?
What options are available to audit login activity? : sql server security
Should you normalize audio?
Mention the different types of replication in sql server.
Explain how to use linked server?
How to drop an existing schema in ms sql server?
Differentiate between mongodb vs. Sql server?
Difference between group by clause and having clause in SQL?
Explain error handling in ssis?
How do I run sql server 2014?
Explain sql server authentication modes?
