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
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
how get the grand total in master-detail report?
What is the difference between user and versatile user?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
How would you format some text using css to be verdana and bold?
How to generate the report from excel sheet?
What is thumbnail?
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?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What we need to discuss with designer before starting the universe designing.
Explain is there any other repository domains rather than universe, security, document?
What is the difference between absolute and relative div positioning?
how to create reports on screech?
What Is Snow Flake Schema?
explain in detail about type 3?
