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
- 20870 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
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
What is the functional & architectural differences between business objects and web intelligence reports?
Difference between b.o 5.1 and 6.1b?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
what is document design in boxi,have u participate in that
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 when we use aggregate awareness function in designer?
When we use aggregate awareness function in designer?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Can more than 1 metric be applied on an analytic in business objects?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
what will be the contents for a functional requirements specifications
Explain about a tricky situation for which you found a very simple solution?
