Sybase Database Interview Questions and Answers
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
Newer Posts
Older Posts
Home
Subscribe to:
Comments (Atom)