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
- 20985 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 |
WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?
What is the difference b/w the simple Universe and Complex Universe?
How we will show the pop message while selecting multiple input values more than 10 in Crystal reports or any other reports?
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...
8. How much supervision have you typically received in your previous job?
What is the difference between business requirement document and use case document.
difference between web intelligence,crystal reports and desktop intelligents
What is the difference between Thin client & thick client?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
What are the difference between merge,auto merge and extended merge ?
i am using Business Objects 6.1(a) facing a problem. ie when we save report in xls format then in xls sheet pictures are inserted into rep file are not come. Is it a bug. Give me answer as soon as possible. Thanks in Advance
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
Teradata 
