Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

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

2285


CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

2110


Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1902


i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2059


in sap bi we have wad, then why we go for sap bo

3335


1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

3527


what is xcelsius architecture?

4530


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2145


Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

1102


Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

951


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

2120


Which command using Query Analyzer will give you the version of SQL server and operating system ?

4974


Explain in detail about type 2(scd),

1060


Can you please send me the migration related issues .

2041


When we use aggregate awareness function in designer?

919