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
- 18137 Views
- RBS, I also Faced
- E-Mail Answers
Answer Posted / aparna
here is some thing diff answer ..
we can use full outer join...if they ask for other then
union condition..
select * from t1 full outer join t2 where t1.id= t2.id..
with some condition
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Explain trigger and its types?
What are audit control procedures?
How to create an index on a view?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is the difference in accessing db between sql server vs sql azure?
Which rendering formats are affected by the pagesize properties?
What is lock escalation and what is its purpose?
What are cursors in ms sql server?
What is the purpose of indexing?
What is difference between index and primary key?
What is user-defined functions? What are the types of user-defined functions that can be created?
What is the correct order of the logical query processing phases?
what are the important architecture components of SSRS?
What is identity?
What is the beast way to write CTE in SQL Server ?
