Interested to Buy Any Domain ? << Click Here >> for more details...
I have 2 tables. Table 1 is employee table and Table2 is
department table. In employee table i have 1,2,3,4,5 emp
id's,in Dept table i have various dept's like a,b,c and i
have 2,3,4 emp id's in my dept table.I joined with these 2
tables.I want the results for equi join means how many
records will fetch.In the same scenario i have to know the
left outer join, right out join and full outer join resuls
means how many records will come. can any body tell me the
answers
- 1 Answers
- 5339 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / bharath
inner join :3 recorde
eno dept
2 a
3 b
4 c
leftouter join: 5records
1 NULL
2 a
3 b
4 c
5 Null
Rigt outer join: 3 records
2 a
3 b
4 c
Null d (if d is not assigned to any employee)
full outer join: 5records
1 Null
2 a
3 b
4 c
5 Null
Null d
Thank you.
| Is This Answer Correct ? | 35 Yes | 0 No |
Post New Answer View All Answers
What are all difference between business objects 6.5 and xi r2?
What is the difference between datawarehousing and businessintelligence?
Explain what would you consider as your biggest achievement and why?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
Explain is data mart?
When to use local filter and when to use global filter?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
Explain the difference between union and group?
Can we configure two instances of CMS pointing to two different CMS system databases?
What is top business?
Explain about a tricky situation for which you found a very simple solution?
Can you please send me the migration related issues .
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
