Correlated vs Noncorrelated Subquery example in SQL

Tutorials Shared by the Internet Community

Advertisements


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 - 27553

  • Total Votes - 161 votes

  • Vote Up - 86 votes

  • Vote Down - 75 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. ...


Site  |   Broken  |   Tweet  |   Facebook  |     |   Save  |   Liked  |   Down

Advertisements