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
- 10954 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 the advantages of shortcuts?
how can you set the image in the report
what is the difference between cascading prompt and drill-thru
-------------How you design DWH?
what is catalog and types of catalogs in cagnos and which is better?
1)what is the use of Deployement and Scheduling? 2)If you have a prompt in your report , after scheduling the report will it run? 3)How can we move our reports from one Environment to Another Environment? 4)What is the complex report in your project and whar are the critical issues have u faced in u r reports and tell me name of some recent reports have u created? 5)What are the limitations of value prompts?
what is power prompt in cognos ep7series?what is the use of this?
How can we convert imr report into Impromptu web report?
2. What functional area you worked on.
Due Date (Highlight Issues in Blue where Due Dates are less than Todays Date),I have only Due Date column then how to over come the problem.How to find out which Due Date are less than Today Date...Kindly provide the detail steps to my mail ID-->asimcognos10@gmail.com
what is mean by cognos powerhouse?
There is any option to delete temp files automatically from temp directory in COGNOS? (without manual)
Teradata 
