Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17664 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
If a stored procedure is taking a table data type, how it looks?
What is index, cluster index and nonclustered index?
What is the difference between ‘having’ clause and a ‘where’ clause?
what is memory-optimized nonclustered indexes
Can you please explain the difference between function and stored procedure?
How to create and drop temp table in sql server?
how can you attach more than 20 ldf files in sql server
What is a synonym for manipulation?
List some major differences between triggers and stored procedures?
What is the difference between a check constraint and a rule?
what is an index? : Sql server database administration
Does a specific recovery model need to be used for a replicated database? : sql server replication
Where is trigger in sql server?
Define outer join in sql server joins?
Can sql servers linked to other servers?
