SQL Subquery
A Subquery is a query within another query. The outer query is called as main query and inner query is called as subquery. A subquery (inner… Read More »SQL Subquery
2,264 total views
Home »
subquery vs correlated subquery
What is Correlated Subquery in SQL?
A correlated subquery is a subquery that uses the values of the outer query and it is evaluated for each row processed by the outer query
A correlated subquery always depends on outer query for its value. Because of this dependency, a correlated subquery cannot be executed independently as a simple subquery .
3,380 total views
What is SubQuery in SQL ?
A Subquery is a query within another query. The outer query is called as main query and inner query is called as sub query.
1,894 total views, 3 views today