What is Correlated sub-query? Please explain



What is Correlated sub-query? Please explain..

Answer / harish

correlated subquery runs once for each row selected by outer the query. it contains reference to a value from the row selected by outer query row.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Cognos Interview Questions

diff b/w grouping and aggregation

1 Answers   HCL,


What is Regular Dimension and Measure Dimensions and Diff b/w them ?

2 Answers  


Cognos TM1 1. What are the different windows in Turbo Integrator? 2. What is the use of advanced window in Turbo Integrator? 3. What is TM1 Workflow. How do you create a process in that? 4. Where is Portlet used. What are differnt windows in portlet. How can you access TM1 web from portlet? Cognos 8. 1. What is Drill-on? 2.How do you implement row level security in Framework Manager? 3. How do you create tree prompt?

1 Answers   HSBC,


What is a dimension?

0 Answers  


Which one is better among Value and select & search prompts,in terms of performance?

2 Answers   L&T,






Create 12 columns for months by writing single case statement?

1 Answers   Wipro,


Can you define a catalog and types of catalogs in cognos?

0 Answers  


plz giv ans . user1 developed some repot ,user2 modify the same report and user 3 also some updates in that same report ? how to indentify that report will be modified r not ?

2 Answers  


Define query items?

0 Answers  


what do u mean by bridge group? where we r using this one?

0 Answers  


Hi Techies, Need your help for achieving this requirement. We have got a requirement to display a report in a page which should diplay max 20 rows but if a report is having totally 17 rows then in the 1st page it has to display 15 rows(divisible by 5) and the other two rows should appear in the next page. Similarly, If a report is having 23 records then in the first page it should display 20 (divisible by 5) and on other page it should display 3 rows. Please advice!

1 Answers   Wipro,


I have 3 objects (list,cross tab and chart)in one page, when u run report display each object in each page. how can i do?

2 Answers   IBM,


Categories