What is the difference between sub-query & co-related sub
query?answer ASAP.......
thanks in advance..............Prakash

Answer Posted / raj

A simple answer with a query will gives you answer for
subquery & co-related sub query.

Select dept, sal from table1
where sal = (select max(sal) from table1
where dept = table1.dept.

Is This Answer Correct ?    5 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

1572


What is a bo repository?

593


Can Bo generates the Report from the cubical data Explain?

1628


Explain the difference between detect alias and detect context?

627


Explain what are the measure objects?

550






If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

694


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

1537


What we need to discuss with designer before starting the universe designing.

1819


Difference between b.o 5.1 and 6.1b?

652


Can we create universe with no cache??

1956


How were the reports scheduled and how to resolve unexecuted documents?

2217


What is a fantrap in business objects?

581


How to generate the report from excel sheet?

585


Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

542


What is the difference in creating filters in designer and business objects?

588