what is an outer join? difference between left outer join
right outer join with an example?
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 is the difference between cascading prompt and drill-thru
Give the advantages of cognos?
what are slowly changing dimensions? Why we are used scd?
Can you define framework manager?
wHAI IS THE DIFFERENCE BETWEEN LIST REPORT AND CROSSTAB REPORT?
faq's on cognos
what is materialised view? why we use it in data warehousing?
what is difference btw summary filter and detail filter, plz explain with example
10 Answers IBM, TCS,
What r the names of the reports that you prepared?
How to test reports in cagonos ?
10 Answers CST, CTS,
What are the batches and it’s details?
How can we improve performance in report studio level?