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
- 17819 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
Can you explain various data region available in ssrs with their use?
What is model database? : SQL Server Architecture
How to insert new line characters into strings?
what are the critical issues you have resloved in your company
What is entity data services?
What are the transaction properties?
How to get a list of columns in a view using "sys.columns" in ms sql server?
Can you leave a union at any time?
when would you go for denormalization? : Sql server database administration
What is default constraint?
What are policy management terms?
Can I delete event logs?
How can you tell if a database object is invalid?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
How to delete an existing database user?
