A subquery is simply s select statement that returns a single value and ca be nested inside a SELECT, UPDATE , INSERT, or DELETE statement. It is also possible to nest a subquery inside another subquery. According to MSDN subquery can be nested upto 32 level. Subqueries are always enclosed in parenthesis and are also called as inner queries.
Liked By
Write Answer
Define Subquery.
Join MindStick Community
You have need login or register for voting of answers or question.
Manish Kumar
26-Nov-2017A subquery is simply s select statement that returns a single value and ca be nested inside a SELECT, UPDATE , INSERT, or DELETE statement. It is also possible to nest a subquery inside another subquery. According to MSDN subquery can be nested upto 32 level. Subqueries are always enclosed in parenthesis and are also called as inner queries.