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
- 5307 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
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
in sap bi we have wad, then why we go for sap bo
Explain what are the steps to be taken to schedule the report?
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?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
can anybody tell me about complicated object you have created
What is the difference between slice and dice and cross tab report?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
What Is Snow Flake Schema?
What Is The Difference Between Oltp And Olap?
Explain about alerts in bos, under what situation we need to use alerts?
Can we configure two instances of CMS pointing to two different CMS system databases?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What is top business?
