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

What is the difference between delete and truncate commands?

1098

Why we use sql profiler?

1023

Where do we use pl sql?

1052

How to create your own reports in sql developer?

1064

When is the update_statistics command used?

1182

What does partition by mean in sql?

1030

How do you update sql?

1038

Can dml statements be used in pl/sql?

1125

What normalization means?

1014

What are pl/sql packages?

1158

Can 2 queries be executed simultaneously in a distributed database system?

1192

What is the difference between union and union all command?

1151

Can a table have no primary key?

1110

how to extract a unit value from a date and time? : Sql dba

1039

How do you declare a variable in pl sql?

1071