What is the difference between sub-query & co-related sub
query?answer ASAP.......
thanks in advance..............Prakash
- 3 Answers
- 19632 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
How would you format some text using css to be verdana and bold?
Explain in detail about type 1?
When to use local filter and when to use global filter?
What is a bo repository?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
Can we create universe with no cache??
What are the steps to be taken to schedule the report?
what are the day to day activities of BO administrator ?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
Can you please send me the migration related issues .
Explain the difference between detect alias and detect context?
What is difference between custom hierarchy and report based hierarchy?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
Explain what are the steps to be taken to schedule the report?
