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

Enlist the advantages of sql.

937

Is left join faster than join?

983

Why is partition used in sql?

1049

What is a database? Explain

1050

Is record in pl sql?

916

Does truncate release storage space?

1013

Show the cursor attributes of pl/sql.

996

What is insert command in sql?

1059

what is an alias command? : Sql dba

1007

How do you use join?

887

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

956

How do you break a loop in pl sql?

985

What are the usages of sql?

1011

How can we solve sql error: ora-00904: invalid identifier?

1164

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

992