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
- 14732 Views
- RBS, I also Faced
- E-Mail Answers
Answer Posted / anil
select * from table1
union
select * from table2
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Give the query of getting last two records from the table in SQL SERVER?
What is spatial and temporal data?
What are cascading parameters in ssrs reports?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What is a join in sql? What are the types of joins?
How to recreate an existing index in ms sql server?
What is ms sql server index?
How to use the inserted and deleted pseudo tables?
Ways to improve the performance of a SQL Azure Database?
What is resource governor in sql server?
What are a scheduled jobs or what is a scheduled tasks?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What is difference between table aliases and column aliases? Do they affect performance?
Define msdb database?
How do I determine how many instances of sql server are installed on a computer?
