what is an outer join? difference between left outer join
right outer join with an example?
- 1 Answers
- 10280 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / m m naidu
OUTER JOIN: It is used to retrieve all the rows from one
table but matched rows from another table
LEFT OUTER JOIN: It displays matched row from two tables
and unmatched row from left hand side table
EX: select a.empno,a.ename,a.sal,b.deptno,b.dname,b.loc
from emp a left outer join dept b on(a.deptno=b.b.deptno)
RIGHT OUTER JOIN: It displays matched rows from two tables
and unmatched row from right hand side table
EX: select a.empno,a.ename,a.sal,b.deptno,b.dname,b.loc
from emp a right outer join dept b on(a.deptno=b.b.deptno)
| Is This Answer Correct ? | 15 Yes | 5 No |
Post New Answer View All Answers
Why cognos decision stream is used?
What is defined as Cognos Impromptu?
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
what is hints in cognos and where we use it.
how you migrate reports to cognos 8 from previous versions?
What is meant by drill down?
What is defined as Query studio?
how can you get the errors in job? when loops are araised we get error?
in u r data u having duplicates how to fetch the latest data in our report?
How to select multiple values from type-in prompt?
Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
Can we test the report other than manual testing?
Can you define drill across?
