How can we acheive correlated sub-query in designer?can anyone help me in this regard?
- 1 Answers
- 1041 Views
- I also Faced
- E-Mail Answers
Answer / Richa Gupta
In ColdFusion, you can achieve a correlated sub-query by using a nested cfquery tag within another cfquery tag. Here is an example:n`n<cfquery name="outerQuery">
SELECT * FROM employees
<cfquery param="id" cfsqltype="CF_SQL_INTEGER">
<!--- Sub-query here --->
</cfquery>n</cfquery>`nnIn this example, the sub-query is correlated because it references a variable (id) from the outer query.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain datawarehousing?
Explain difference between view and materialized view?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
What is XMLA ?
What is the capacity of power cube?
What is the main difference between star and snowflake star schema? Which one is better and why?
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF ORACLE 8I
3 Answers IBM, Ness Technologies,
What should I have in mind when building olap solution from scratch?
What are the different problems that ?Data mining? can solve?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
Give me a broad concept of what a data warehouse is, and what it might be used for?
What is cfapplication tag?
Teradata 
