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
- 15924 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
How to add the custom code in Report?
Do you know what guidelines should be followed to help minimize deadlocks?
What are magic tables in sql server?
How to set a database state to offline in ms sql server?
how can you attach more than 20 ldf files in sql server
Explain aggregate functions?
How to use values from other tables in update statements in ms sql server?
what protocol both networks use? : Sql server database administration
How to view existing indexes on an given table using sp_help?
Explain full-text indexing?
Tell me in brief how sql server enhances scalability of the database system?
What is change data capture (cdc) in sql server 2008?
What is the partitioning method?
What are the advantages of sql azure?
Call by value and call by reference in procedure and function, with NOCOPY.
