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
- 5421 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
How would you format some text using css to be verdana and bold?
Explain how to schedule the report in b.o?
Explain the difference between union and group?
What Is Snow Flake Schema?
How were the reports scheduled and how to resolve unexecuted documents?
8. How much supervision have you typically received in your previous job?
how many reports have u created ? explain a few.
How to schedule the report in b.o?
What are the steps to do to use alerts in bo?
When we use aggregate awareness function in designer?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
What sort of existing documents should business analysts refer to when starting on a new project?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
What is the difference between user and versatile user?
what are the tables used in health care domain project and columns used in report?
