what is the difference between the query and corelated
query
Answer Posted / saurabh
When 1st main query is executed then the result of the main
query is used in teh where clause of subquery then this
type of subquery is called as co-related sub query.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Which is faster count (*) or count 1?
What is sql partition?
What is the difference between the conventional and direct path loader? : aql loader
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
How can I get the number of records affected by a stored procedure?
What is sql clause?
what are ddl statements in mysql? : Sql dba
What's the difference between inner join and left join?
What is online transaction processing (oltp)?
Explain the uses of control file.
Difference between truncate, delete and drop commands?
what is the difference between a local and a global temporary table? : Sql dba
How to use sql statements in pl/sql?
What is a sql schema used for?
What are basic techniques of indexing?