¿Cuál de las siguientes afirmaciones sobre subconsultas correlacionadas es correcta? ejemplo de código

Ejemplo: qué son subconsultas correlacionadas y no correlacionadas

Noncorrelated Subqueries
A noncorrelated subquery executes independently of the outer query. The subquery executes first, and then passes its results to the outer query, For example:

=> SELECT name, street, city, state FROM addresses WHERE state IN (SELECT state FROM states);

Correlated Subqueries
A correlated subquery typically obtains values from its outer query before it executes. When the subquery returns, it passes its results to the outer query.

=> SELECT name, street, city, state FROM addresses
     WHERE EXISTS (SELECT * FROM states WHERE states.state = addresses.state);

---

---

Utiliza Nuestro Buscador