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
- 17293 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
What is the default fill factor value?
What are the disadvantages of merge replication?
What type of locking occurs during the snapshot generation? : sql server replication
What is enhanced database mirroring in sql server 2008?
What is auditing in sql server?
Explain why variables called the most powerful component of ssis?
Explain nested trigger in sql?
What is sql server locking?
What is normalization 1nf 2nf 3nf?
What is meant by referential integrity?
Is there any difference between primary key and unique with the not null condition?
What are page splits? : SQL Server Architecture
What is after dml trigger?
How to add an address record into adventureworkslt?
How do you use a subquery to find records that exist in one table and do not exist in another?
