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 function of cognos dispatcher?
if we have a value prompt in a prompt page and if we need to pass that prompt value to a sql used in report, what is the sql code? give me example?
what is requery in cognos?
What is Additive function?
What is model filter?
Hi, I Want To Display The Report. From MOnday To Friday By Using Date Prompt.PLs Expain To Me...
What is defined as data mining?
If you have a report with list and cross tab in the same page. How do you restrict one user can see only the list and the other user can see both.
What is dtm?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
How can we improve performance in framework manager level?
5. Which type of report you build more, list, crosstab or chart and why?