What is the difference between sub-query & co-related sub
query?answer ASAP.......
thanks in advance..............Prakash
- 3 Answers
- 20156 Views
- iFlex, Maintec, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ram
partially parent query will excute(this will give some out
put).these output will use in sub query,after parent query
fully excuted.sub query depend on parent query.
| Is This Answer Correct ? | 2 Yes | 4 No |
Answer / raj
A simple answer with a query will gives you answer for
subquery & co-related sub query.
Select dept, sal from table1
where sal = (select max(sal) from table1
where dept = table1.dept.
| Is This Answer Correct ? | 5 Yes | 12 No |
What is a fantrap in business objects?
when and where we use @varialble function
What are the diffrences between Business Objects 5.1 & 6.5 ?
what is traffic lighting in business objects?
what is confirm dimension ?
u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how we give the link these 2 sources
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
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...
How will solve a loop caused by lookup table without using alias?
could you please give me the diagram of BO 6.5 Architecture or explain about the tires?
WHAT IS SYNCHRONIZATION IN BOXI?
Suppose i have the sinario like this column1: e1,e2,e3,e4 : column2: 1,0,1,0 : column3: M,F,M,F : in this i want to disply 1 is male and 0 is female which is added to the another column like column 4 what is the process?
Teradata 
