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
- 15328 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
Describe triggers features and limitations?
What are the basic functions for master, msdb, model, tempdb databases?
How to access the deleted record of an event?
What are the steps you can take to avoid “deadlocks”?
What is difference between getdate and sysdatetime in sql server 2008?
How do you delete a data source?
How to reaname table name without using sp_Rename in sql server..?
How to list all stored procedures in the current database using ms sql server?
What is the importance of three tier architecture?
What is the difference between ddl and dml?
what's sql server? : Sql server database administration
How to list all login names on the ms sql server?
How to provide default values to function parameters?
How to create new tables with "select ... Into" statements in ms sql server?
What are system databases in ms sql server?
