How can we acheive Correlated sub-query in Designer?
Answer Posted / prabha
A correlated subquery is a SELECT statement nested inside
another T-SQL statement, which contains a reference to one
or more columns in the outer query. Therefore, the
correlated subquery can be said to be dependent on the
outer query. This is the main difference between a
correlated subquery and just a plain subquery. A plain
subquery is not dependent on the outer query, can be run
independently of the outer query, and will return a result
set. A correlated subquery, since it is dependent on the
outer query will return a syntax errors if it is run by
itself.
| Is This Answer Correct ? | 5 Yes | 17 No |
Post New Answer View All Answers
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
What would you consider as your biggest achievement and why?
how get the grand total in master-detail report?
Explain what are the measure objects?
What is a fantrap in business objects?
How to execute the plsql procedure from the report by clicking with mouse?
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
What is the difference in creating filters in designer and business objects?
What is difference between webi and infoview?
8. How much supervision have you typically received in your previous job?
Explain how we drill up week to month?
How to schedule the report in b.o?
Which versions are used in the bo dashboard work?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?