Define Subquery.
1137
26-Nov-2017
Updated on 19-Sep-2020
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.