Breaking News: Grepper is joining You.com. Read the official announcement!

what are correlated and non correlated subquery

M. Wasim Abbasi answered on November 6, 2020 Popularity 9/10 Helpfulness 4/10

answer what are correlated and non correlated subquery

related correlated subqueries

what are correlated and non correlated subquery

Comment

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);

Popularity 9/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: correlated correlated-subquery sql

Link to this answer
Share Copy Link

Contributed on Nov 06 2020

M. Wasim Abbasi

0 Answers Avg Quality 2/10

Closely Related Answers

correlated subqueries

Comment

ELECT column1
FROM table1 AS outer
WHERE condition operator
   (SELECT column2
    FROM table2 AS inner
    WHERE inner.column3 = outer.column4);

Popularity 7/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: correlated sql

Link to this answer
Share Copy Link

Contributed on Nov 02 2023

Yellowed Yak

0 Answers Avg Quality 2/10

correlated subqueries

Comment

SELECT column1
FROM table1 AS outer
WHERE condition operator
   (SELECT column2
    FROM table2 AS inner
    WHERE inner.column3 = outer.column4);

Popularity 6/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: correlated sql

Link to this answer
Share Copy Link

Contributed on Nov 02 2023

Yellowed Yak

0 Answers Avg Quality 2/10

what are correlated and non correlated subquery

Contents

More Related Answers

what are correlated and non correlated subquery

Closely Related Answers

correlated subqueries

correlated subqueries

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.