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 are the data types present in bo? What happens if we implement view in the designer and report?
Explain the data types present in bo and what happens if we implement view in the designer and report?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
What is thumbnail?
Explain in detail about type 2(scd),
Give some information on report bursting?
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
What is difference between webi and infoview?
What is package in BO
8. How much supervision have you typically received in your previous job?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
Explain how to execute the plsql procedure from the report by clicking with mouse?
What is object stores?