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 procedure and function in sql?

993

what is the syntax used for partition in tsql? : Transact sql

1013

How do you identify a primary key?

1061

what are date and time data types in mysql? : Sql dba

965

What is the starting oracle error number? What is meant by forward declaration in functions?

987

what is the difference between primary key and unique key? : Sql dba

1034

How do you go back in sql?

984

What does trigger mean in slang?

1048

Why do we create views in sql?

1147

Explain spool.

1174

what is the difference between inner and outer join? Explain with example. : Sql dba

1021

What is sql in java?

1074

how to convert dates to character strings? : Sql dba

1163

Are pl sql variables case sensitive?

1044

What is left join in sql?

1043