What is the difference between sub-query & co-related sub
query?answer ASAP.......
thanks in advance..............Prakash
- 3 Answers
- 19637 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 |
I have two data providers with common dimension and measures. The only difference between two data providers is in condition 'Fiscal Year'.One data provider calculates for current year and other one calculates for previous year. So in prompts if I am passing 2008 as current year then the two data providers should be able to calculate for current year and previous year individually. So Can anybody tell me how to do calculation in data providers. ( I am using BO WebI report )
1. what is the purpose of creation of universe than other data sources ? 2. which is the best method in performance tuning techniques ?
what is static filter and dynamic filter
how to link 3 fact tables
How to link two different universes ?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
how change the order of prompts in bo xi? eg. i create first prompt with 'year' and second prompt with 'city'. my question is to display the 'city' prompt first .what can i do for it ?
What is the use of linling the universes?Thanks in advance
in xir2 how to send reports to end user
Difference between Object varification and validation
can i use stored procedure in webi?
what is confirm dimension ?
Teradata 
