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

Explain is it the job of a business analyst or systems analyst to draw the class diagram?

1040


Explain what are the steps to do to use alerts in bo?

1076


Explain the data types present in bo and what happens if we implement view in the designer and report?

1033


Explain what sort of existing documents should business analysts refer to when starting on a new project?

1009


Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3843


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

2253


Explain about a tricky situation for which you found a very simple solution?

1008


How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4720


Explain about a time when you discovered a more efficient way to do a work task?

1148


Can we configure two instances of CMS pointing to two different CMS system databases?

2034


What is report template in b.o?

1014


What task is 98% of the required work of a business analyst?

1052


What is a bo repository?

1046


how to create reports on screech?

2560


What are the data types present in bo? What happens if we implement view in the designer and report?

1031