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 which versions are used in the bo dashboard work?

1125


Explain what is the difference between slice and dice and cross tab report?

1134


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?

1072


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

1172


what is universe null

2461


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

1361


What is the difference between business requirement document and use case document.

1063


Can you please send me the migration related issues .

2105


Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

1082


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 ?

2096


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

1059


What is the difference between slice and dice and cross tab report?

1108


IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

10508


Explain what is the difference between business requirement document and use case document.

1070


Explain what three things do you consider to be the most important factors for a manager?

1051