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
- 17322 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 do you improve the performance of a SQL Azure Database?
How to find the login name linked to a given user name?
How can you ensure that the database and sql server based application perform well?
Explain what is the function of sql server agent windows service?
What is a database table?
What is history table in sql server?
How to retrieve error messages using mssql_get_last_message()?
how you can move data or databases between servers and databases in sql server? : Sql server administration
Write a program to fetch first 10 records from a file?
What is 2nf normalization form?
How to return the second 5 rows in ms sql server?
What is difference between aggregate and analytic function?
Explain external key management in sql server 2008
What are key, name and value columns of an attribute? : sql server analysis services, ssas
What is difference in performance between insert top (n) into table and using top with insert?
