what is different between inline query,subquery& corelated
query?
- 8 Answers
- 102975 Views
- Quest, I also Faced
- E-Mail Answers
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
How many segment are present in Oracle Manufacturing
key flexfield structure
Difference between transaction type and transaction sources. : oracle accounts receivable
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
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?
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
What are different types of transactions in ar? : oracle accounts receivable
What is the sql query to find the employee who has Nth maximum salary?
A scenario for amount correction & how to use amount correction functionality in AP invoices
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
What view would you use to determine free space in a tablespace?
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
