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
- 20893 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 |
Explain what task is 98% of the required work of a business analyst?
how do you give security to universe ?
2 Answers InfoStep, Tech Mahindra,
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
I need to modify Web Intelligence Report, I need to Add 7 columns in WEBI Report-Java Pannel, so i could Add only 6 Columns in the Webi-Java Pannel as one X Table - X Column is not available in the Universe. I was advised that i can do it with Free Hand SQL in Web Intelligence even X Table - X Column is not available in Universe. Please kindly let me know how to implement the same
How we drill up week to month?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGNING UNIVERSES?
how to coneect to a server in a business objects
Shall we connect to the oltp systems directly .,
how to do Ad-hoc reporting ?
Explain what are the steps to do to use alerts in bo?
Report have 10000 records,how to restrict the end user to 1000 Records?
how we transport universes from business objects 6.5 to BOXI R2?
Teradata 
