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
Differentiate between transaction type and transaction source? : oracle accounts receivable
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
What is the difference between conversions and interfaces? : oracle accounts receivable
how to replace not in with not exist?
What Are Cross Validation & Adi?
difference of using cursor for loop and open,fetch,close.which one is better
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
What is the disk migration? what is the steps involved in oracle disk migration?
types of receipts and detail desription about recipts and tables effected by receipts?
What view would you use to determine free space in a tablespace?
What is the difference between oracle media recovery and crash recovery?
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
Explain about party and customer in ar : oracle accounts receivable
What is supporting issues GL AP and AR?