beanbrain
Programmer
- Dec 31, 2001
- 170
How many nested sub-queries are allowed?
Why?
Why?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Nested sub-queries
- Thread starter beanbrain
- Start date
- Status
That's DBMS-specific. I don't believe that the ANSI-SQL standard (for which this is the forum) defines limits like that.
Where such limits do exist its probably tied to some decision made by a programmer deep in the internals of the DBMS code. Why? Probably because he (or she) could.
Where such limits do exist its probably tied to some decision made by a programmer deep in the internals of the DBMS code. Why? Probably because he (or she) could.
- Thread starter
- #3
beanbrain
Programmer
- Dec 31, 2001
- 170
Golom:
Thanks for the answer. I actually got some pretty good ones from a DBA I know.
Sybase allows a maximum of sixteen (16) sub-queries.
MS SQL server allows two hundred fifty three (253) sub-queries.
Oracle has no upper limit though I'm sure there must be a functional limit at some point.
He did not know about MySQL or any of the lesser packages.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
Thanks for the answer. I actually got some pretty good ones from a DBA I know.
Sybase allows a maximum of sixteen (16) sub-queries.
MS SQL server allows two hundred fifty three (253) sub-queries.
Oracle has no upper limit though I'm sure there must be a functional limit at some point.
He did not know about MySQL or any of the lesser packages.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
- Status