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
- 20755 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
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
Explain what would you consider as your biggest achievement and why?
how to create metric universe ?
What are the steps to do to use alerts in bo?
Is there any other repository domains rather than universe, security, document?
What is difference between webi and infoview?
Explain the difference between union and group?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
What is the difference between user and versatile user?
What is report template in b.o?
how to create reports on screech?
Explain what is the difference between slice and dice and cross tab report?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
Explain is there any default username & pwd for bo designer & supervisor?
