Correlated Query: If a sub query has a Reference with the value or values

what is the difference between the query and corelated
query

Question Posted / guru

Answer Posted / guru

Correlated Query: If a sub query has a Reference with the
value or values of Main Query , It is called as Correlated
Sub query.

Thanks

Is This Answer Correct ?

11 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How is a process of pl/sql compiled?

598

What is oracle sql called?

504

What do you understand by pl/sql cursors?

546

How to revise and re-run the last sql command?

646

What is pl/sql language case sensitive?

631

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

718

What are the subsets of sql?

547

What is a left join?

507

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

551

Does user triggers have entry for trigger with compilation errors?

594

Why schema is used in sql?

515

What is a delimiter in sas?

546

what is sub-query? : Transact sql

596

What does over partition by mean in sql?

531

Is inner join faster than left join?

630