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
- 20976 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 |
How to restrict the user to refresh or Run the report only 1 time in BO?
WHAT IS THE DIFFERENCE BETWEEN OLAP AND DATAWAREHOUSE? WHAT IS MICROCUBE EXACTLY?
Explain about a task that really tested your analytical abilities?
WHAT ARE THE TYPES OF UNIVERSES?PLZ EXPLAIN IT
9 Answers Business Intelligence Analytics, SRA,
what is performance tunning in BO in report level& designer level?
What is the error that occurs while detecting the cardinalities in the universe pane if we create a join between the normal table and the aggregate table...
How many universes are required for a single project,and how many reports are required for a single Universe.
any of the person working on encyclopedia? give the explanation briefly?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
what is the difference b/w the refresh and buffered data?
HOw do u migrate from old version to the new version?
can anybody tell me about issues faced while creating reports
1 Answers Accenture, Tech Mahindra,
Teradata 
