what is an outer join? difference between left outer join
right outer join with an example?
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
Define dimensions?
What is defined as data mining?
how to explain health care project and which reports we can create in health care doain?
How to test a cube?
When we save a report in report studio with what extn it save?
What is the model filter?
What is a Transformer?
What is the function of model design accelerator?
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
what are the names of the reports that you prepared?
What do you understand by the term 'aggregate cache'?
dumps needed ASAP for - C2020-180 Cognos IBM Certification
how you migrate reports to cognos 8 from previous versions?
is there any difference between operational database and data base?if yes what r they?
What do you understand by the term 'dynamic cube'?