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

Which sql statement is used to delete data from a database?

959

What are transaction and its controls?

1040

What are sql commands?

1014

How run sql*plus commands that are stored in a local file?

1061

What is rename command in sql?

1036

Is grant a ddl statement?

896

What is $$ in sql?

992

How many sql statements are used?

1011

What is sql performance tuning?

921

Does inner join return duplicate rows?

978

What is the difference between execution of triggers and stored procedures?

1116

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

975

What are the types of dbms?

975

Explain 3 basic parts of a trigger.

1323

Write the command to remove all players named sachin from the players table.

1184