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
- 17668 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
How to populate a table in sql server?
What is function of CUBE ?
How to select some specific rows from a table in ms sql server?
how to control the amount of free space in your index pages? : Sql server database administration
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
What is the difference between migration and upgradation in sql server?
explain different levels of normalization? : Sql server database administration
Do you know exporting and importing utility?
What is transaction server explicit transaction?
How can you hide the sql server instances?
What is an execution plan? When would you use it?
Can You Use Data Mining Models In Ssrs?
What are acid properties of transaction?
Explain what is cte (common table expression)?
What is change tracking in sql server?
