|
Can anybody give the best exaplanation for the diffrence between sub-query and nested query?
(comments are locked)
|
|
As grant says, the things you have mentioned are one and the same. You basically have: A sub-query - this is a query which is used as part of a larger query. Much as you would select from a table, you can select from a sub-query. A correlated sub-query - this is a particular type of sub-query that references the outer query - it's used for exists, having etc. A scalar sub-query - this is where you use a sub-query more like a column - to pick up a single value from somewhere. Hope that helps... is it that,nested query executes for more numebr of times within a sub-query?
Mar 19 '10 at 06:57 AM
venkatreddy
For extra credit...what is so special about a nested query that it deserves its own explicit linked server property? Allowing a recursive cte seems more apposite for first-class citizenship
Mar 19 '10 at 08:03 AM
Scot Hauder
(comments are locked)
|
|
To my knowledge, that's two terms for the same concept.
(comments are locked)
|
