What is the difference between a sub-query and a correlated sub-query?
Ans: A subquery is a query that SQL Server must evaluate before it can process the main query. It doesn’t depend on a value in the outer subquery. A correlated subquery is the one that depends on a value in a join clause in the outer subquery
No comments:
Post a Comment