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
- 18139 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
Explain what is dbcc?
Give me any three differences between Truncate and Delete.
Explain table valued parameters in sql server? Why tvp used?
Which sql server table is used to hold the stored procedure script?
What are the disadvantages of merge replication?
what are the different ways to return the rowcount of a table?
How do I find sql server instance name?
Your table has a large character field there are queries that use this field in their search clause what should you do?
How to set database to be single_user in ms sql server?
What are various aggregate functions that are available?
Explain the different types of joins?
What is 2nf in normalization?
How do you delete duplicate records in sql server?
When a primary key constraint is included in a table, what other constraints does this imply?
What is the stuff and how does it differ from the replace function?
