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
- 17474 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
What is checkpoint process in the sql server?
Explain different types of self contained sub query?
What is the difference between a function and a trigger?
What are extended events in sql server?
What is log in sql server?
What is the use of “join” in sql server?
What are the advantages of policy management?
What is a data source or ds? : sql server analysis services, ssas
How to create a view using data from another view?
How to Update from select query in sql server?
Explain an incremental backup?
How many cores do I need for sql server 2016?
what is sql server? : Sql server database administration
What different steps will a sql server developer take to secure sql server?
can you implement data mining in SSRS?
