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
- 5348 Views
- IBM, I also Faced
- E-Mail Answers
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 |
What is the strategies ? what is the need of the strategies?
Explain what three things do you consider to be the most important factors for a manager?
What is meant by data federator and what is the use of it?
How to create predefined filters in B.O.
When a report in Web intelligence is created with ten objects and save the same as PDF the report divides the report into two pages. One page with data for five objects and the other with next five objects? Is there a way to combine these ten columns in a single page view?
What is a bo repository?
without creating the business view is there possible to create & generate the Crystal reports?
. User wants to modify a report and wants to add additional data. How will you approach.
how do u implement dense rank in bo reports?
IS THERE ANY MINIMUM RQUIREMENT TO DEFINE CONTEXT?
Can any please explain FOR EACH AND FOR ALL?
What is top business?
Teradata 
