Define Subquery.

Total Post:123


 471  View(s)
Rate this:
  1. Define Subquery.

    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.