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

What is the profile and package?

1760


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

1814


What is the difference between condition & filter?

600


what is document design in boxi,have u participate in that

1657


BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

1714






Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

1579


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

3840


Explain is there any default username & pwd for bo designer & supervisor?

591


How to restrict password to a user while sending a document in .pdf format

1850


what are the tables used in health care domain project and columns used in report?

4031


Can more than 1 metric be applied on an analytic in business objects?

1647


What are the steps to be taken to schedule the report?

549


any difficulitis have you phase while creating bo reports and how did u solve it

2986


Difference between zabo and webi?

633


what will be the contents for a functional requirements specifications

1778