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
- 14580 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
State the difference between union and union all?
How do you Implement SSIS Packages in your Project?
In what sequence sql statement is processed?
What is a natural primary key?
What are the types of lock supported by ?
What is the purpose of sql profiler in sql server?
What are drillthrough reports?
What is reference section?
How to declare a cursor with "declare ... Cursor" in ms sql server?
what is the difference between openrowset and openquery?
Can we insert data if clustered index is disabled?
What is the syntax for encrypting a column in SQL Server?
What is key set driven?
What is difference between primary key and foreign key?
What is the stuff?
