SQL Server - Sub- Query & Corelated Sub Query | Difference b/w Sub Query and Corelated Sub Query

A Subquery or Inner query or a Nested query is a query within another SQL query and embedded within the WHERE clause. A subquery is used to return data that will be used in the main query as a condition to further restrict the data to be retrieved. ... The BETWEEN operator cannot be used with a subquery.

In a SQL database query, a correlated subquery (also known as a synchronized subquery) is a subquery (a query nested inside another query) that uses values from the outer query. ... Again, because the subquery is correlated with a column of the outer query, it must be re-executed for each row of the result.

Видео SQL Server - Sub- Query & Corelated Sub Query | Difference b/w Sub Query and Corelated Sub Query канала PracticalIT