Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between sub-query & co-related sub
query?answer ASAP.......
thanks in advance..............Prakash
- 3 Answers
- 20890 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
What is the difference in creating filters in designer and business objects?
How to create Index to the table in the universe designer and how it improves the Query performence
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
What is the difference between the public object&schema object?
Which versions are used in the bo dashboard work?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain the difference between detect alias and detect context?
What is the difference between business requirement document and use case document.
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
Explain the data types present in bo and what happens if we implement view in the designer and report?
Explain difference between zabo and webi?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
What sort of existing documents should business analysts refer to when starting on a new project?
