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 a materialized view? : Sql dba

1125

Can we write ddl statements in functions?

1180

What is indexes?

1113

How do we accept inputs from user during runtime?

1115

Can we call stored procedure in function?

998

How to select all records from the table?

1179

Is a table valued function object?

1069

how many values can the set function of mysql take? : Sql dba

1030

Explain the components of sql?

1105

What is sharding in sql?

1038

What is the mutating table and constraining table?

1075

What does the hierarchical profiler does?

1119

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

1011

What are the two characteristics of a primary key?

1029

What is sql key?

1042