What is the difference between sub-query & co-related sub
query?answer ASAP.......
thanks in advance..............Prakash
- 3 Answers
- 19624 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
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
Explain when to use local filter and when to use global filter?
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 difference between webi and infoview?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Explain how many universes can be created in a project?
Can you please send me the migration related issues .
what is xcelsius architecture?
When we use aggregate awareness function in designer?
Explain about alerts in bos, under what situation we need to use alerts?
how to create reports on screech?
What is the difference in creating filters in designer and business objects?
What is the difference between datawarehousing and businessintelligence?
What is the difference between absolute and relative div positioning?
