Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / srini
Some times the main query needs a driving query in FROM
clause, which is not possible to build. So we use derived
tables to fix this.
Example:
SELECT
----
FROM
TABLE1,
( SELECT
---
FROM
TABLE2
)DERIVED_TABLE
WHERE
TABLE1.COLUMN = DERIVED_TABLE.COLUMN;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the dense rank?
Differences between business objects and web intelligence reports?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
Give some information on report bursting?
When we use aggregate awareness function in designer?
what is the difference b/w the refresh and buffered data?
What is the functional & architectural differences between business objects and web intelligence reports?
What is a bo repository?
Explain how to schedule the report in b.o?
Difference between b.o 5.1 and 6.1b?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
What would you consider as your biggest achievement and why?
What is top business?
