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
- 17325 Views
- RBS, I also Faced
- E-Mail Answers
Answer Posted / sushama kumari
select col1,col2 from table1 union table2 is an incorrect
answer.
Following 2 are corrcet answers:
1.
select * from table1
union
select * from table2
2.
select col1 from table1
union
select col2 from table2
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Tell me when is the update_statistics command used?
How to create new tables with "select ... Into" statements in ms sql server?
Give the query of getting last two records from the table in SQL SERVER?
What is the definition for sql server 2000?
When would you use a before or after trigger?
Tell me about joins in database system and explain each in detail.
List the different index configurations possible for a table?
When a primary key constraint is included in a table, what other constraints does this imply?
How to throw custom exception in Stored Procedure?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
What is the exact numeric data type in sql?
What is the difference between Clustered and Non-Clustered Index?
Give an example of SQL injection attack ?
What is log cache in sql server?
What is default constraint?
