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

What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1038


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2255


if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2063


please send me oracle pl/sql exp resume. and also faqs...

2488


what are the API of GL,PO,AP

2262


What do you mean by Oracle MEDIA RECOVERY?

1217


How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?

2404


Explain the payment term in ar. : oracle accounts receivable

1101


Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

1287


what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2094


What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

1271


IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

2252


1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

2180


PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2210


hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

2226