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
- 15320 Views
- RBS, I also Faced
- E-Mail Answers
Answer Posted / amit
select * from table1
union
select * from table2
| Is This Answer Correct ? | 21 Yes | 5 No |
Post New Answer View All Answers
What is the difference between set and select?
How many database files are there in sql server 2000?what are they?
Tell me in brief how sql server enhances scalability of the database system?
What are the steps to insert a table?
What are distributed partitioned views?
How to create a dynamic cursor with the dynamic option?
What is the report builder?
What is transaction server isolation?
How to list all field names in the result set using mssql_field_name()?
What does it mean to invest in the index?
How do I view a script in sql server?
How to define output parameters in stored procedures?
How do I setup a local sql server database?
Explain external key management in sql server 2008
What are page splits? : SQL Server Architecture
