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
- 17798 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
How much is a sql server license?
What is SQL Azure Federations?
What is multi-statement table-value user-defined function?
What is logon trigger?
What’s the use of custom fields in report?
What is the concept of optimization?
How many triggers you can have on a table?
How retrieve field names from the table in SQL through JAVA code?
How to defragment indexes with alter index ... Reorganize?
How to connect of datebase with sql express.?
How to delete existing triggers using "drop trigger"?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
what is isolation level at dead lock?
how to do partition in sqlserver
What are the commands used in DCL?
