What is the difference between sub-query & co-related sub
query?answer ASAP.......
thanks in advance..............Prakash
- 3 Answers
- 19597 Views
- iFlex, Maintec, TCS, I also Faced
- E-Mail Answers
Answer Posted / soujanya
Nesting of queries, one within another, is termed as a Sub-
Query.
A sub query is executed once for the parent statement
whereas the correlated sub query is executed once for each
row of the parent query.
Example
Select deptno, ename, sal from emp a
where sal = (select max(sal) from emp
where deptno = a.deptno)
order by deptno
| Is This Answer Correct ? | 52 Yes | 9 No |
Post New Answer View All Answers
Which versions are used in the bo dashboard work?
how many reports have u created ? explain a few.
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
What is the profile and package?
How we drill up week to month?
Can you please send me the migration related issues .
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
What three things do you consider to be the most important factors for a manager?
Explain what three things do you consider to be the most important factors for a manager?
What is package in BO
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
What is top business?
What is a fantrap in business objects?
