Correlated vs Noncorrelated Subquery example in SQL

Synopsis

Main difference between Correlated and Noncorrelated subquery is that, Correlated subquery depends upon Outer query and can not execute by its own whi

Statistics

  • Total Hits - 49361

  • Total Votes - 190 votes

  • Vote Up - 96 votes

  • Vote Down - 94 votes

  • Domain - javarevisited.blogspot.com

  • Category - Basic SQL/Advanced SQL

  • Submitted By - Javin Paul

  • Submitted on - 2012-11-01 15:35:43

Description

Main difference between Correlated and Noncorrelated subquery is that, Correlated subquery depends upon Outer query and can not execute by its own while in Noncorrelated subquery both outer query and inner query are independent to each other.

Source Website

Please use the following link to visit the site. There is a possibility that this content has been removed from the given URL or may be this site has been shut down completely.

http://javarevisited.blogspot.com/2012/07/subquery-example-in-sql-correlated-vs.html

Broken  |   Save  |   Liked  |   Down

Advertisements