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
- 10964 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the considerations regarding performance kept in mind while setting up cognos?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
Can you define drill across?
What is the deployment requirements used in cognos?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
What is meant by junk dimension?
What is the difference between the content store and content manager?
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
What is zero-foot print?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
What are shortcuts? Where it can be used? What are the advantages?
What are the types of studio present in Cognos?
What is a Pivot?
Explain the difference between powerplay transformer and power play reports?
WHAT ARE THE DISTNICT VARIABLES?
