What is subquery in SQL - Correlated vs NonCorrelated Suquery Example
7
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.
Popular Articles by this blogger
- Database Transaction Tutorials on SQL Series
- Top 10 Google Interview questions answers for Software Enginner Interview
- How to Convert List to Set in Java with Example
- How to measure execution time in Java
- XPath Tutorials and notes for Java Programmer
- How to read XML File using SAX parser in Java with Code Example
- Quick overview of JUnit4 Annotations with Example
- How to run your first Java program from command prompt