what is an outer join? difference between left outer join
right outer join with an example?
- 1 Answers
- 10084 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
What is called cognos reporting tool?
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
Can you define drill down and drill up?
Write types of folders present in cognos?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
Tell me about Dnamic and Static Dashboards?
What you mean by drill across?
how u will determine the performence tune will occur either in report or system
What is the function of model design accelerator?
What are slice and dice?
how to perform back drill through in cognos 8 what is the use of it
Write some methods to apply securities in framework manager model?
What are various types of gateways in cognos?
Name the types of report?
What are all the types of gateway used in Cognos?
