DBA > Job Interview Questions > Microsoft SQL Server FAQs

What is a correlated sub-query? How can these qu

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is a correlated sub-query? How can these queries be useful?

The more seasoned developer will be able to accurately describe this type of query. A correlated sub-query is a special type of query containing a sub-query. The sub-query contained in the query actually requests values from the outside query, creating a situation similar to a loop. You can find a more detailed description as to how these special types of queries work in this article.

Other Job Interview Questions