what is an outer join? difference between left outer join
right outer join with an example?
- 1 Answers
- 10053 Views
- HCL, I also Faced
- E-Mail Answers
Answer / 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 |
What are links & Segments in Cognos Framework Manager?
What is Additive function?
What is difference between content store and content manager?
How can you create prompts in framework manager?
What is Normalization?
if u having 2 pakages i want a report with report items in 2 pakages how to use the 2 pakages in single report please ans me............
Can you define fan trap?
In which types of reports does the page breaks applicable in Cognos...?
What is the difference between cognos 8.2 and cognos 8.3?
Are you aware of any limitations in Cognos?
what is an sid (surrogate key)?
what is cube size?
Teradata 
