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 different between inline query,subquery& corelated
query?

Answer Posted / dhana

A correlated subquery is a SELECT statement nested inside
another T-SQL statement, which contains a reference to one
or more columns in the outer query. Therefore, the
correlated subquery can be said to be dependent on the outer
query. This is the main difference between a correlated
subquery and just a plain subquery. A plain subquery is not
dependent on the outer query, can be run independently of
the outer query, and will return a result set. A correlated
subquery, since it is dependent on the outer query will
return a syntax errors if it is run by itself.

Is This Answer Correct ?    57 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between transaction type and transaction source? : oracle accounts receivable

1116


what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2281


What is the use of lockboxes? Steps for lock box : oracle accounts receivable

1396


What is the difference between conversions and interfaces? : oracle accounts receivable

1238


how to replace not in with not exist?

3744


What Are Cross Validation & Adi?

1162


difference of using cursor for loop and open,fetch,close.which one is better

1806


WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2113


What is the disk migration? what is the steps involved in oracle disk migration?

1225


types of receipts and detail desription about recipts and tables effected by receipts?

2075


What view would you use to determine free space in a tablespace?

2226


What is the difference between oracle media recovery and crash recovery?

1176


Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1147


Explain about party and customer in ar : oracle accounts receivable

1211


What is supporting issues GL AP and AR?

2563