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
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
how to create reports on screech?
What sort of existing documents should business analysts refer to when starting on a new project?
What is the difference between user and versatile user?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
how to prepare the documentation in business objects and where to get the requirement?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
Is there any other repository domains rather than universe, security, document?
is it possible to export the webi reports to crystal reports?with out using businessview?
What is the functional & architectural differences between business objects and web intelligence reports?
Explain how to execute the plsql procedure from the report by clicking with mouse?
What is thumbnail?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server