Interested to Buy Any Domain ? << Click Here >> for more details...
what is an outer join? difference between left outer join
right outer join with an example?
- 1 Answers
- 11120 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 |
15. If I select the current month and year how can we display previous 11 months data?
What are the different uses of a repository manager?
-----------------What is Direct and Conventional loading?
What is meant by Reportstudio shortcut?
WHAT SHOULD BE DONE WHEN A REPORT RUNNING TIME WILL TAKE LONG TIME IN CONGNOS?
2 Answers ABC Infotech, Virtusa,
What is Star schema group?
Explain what is the difference between microstrategy and cognos reporting tool?
What is content Manager?
set scope level in transformer
How can I change reports to another package???
what is symmetric key?where do u use this?
Hi, I am Searching on Cognos 10, If any experienced person can send out a project or explain a realtime scenario that would be very helpful for me. Please be kind towards me and help me in this regard. I am really finding difficult to find a person who can guide me in this feild. Your help will be highly appriciated. My email id is asimcognos10@gmail.com. Hope you will help....
Teradata 
