Define Subquery.

Total Post:123

Points:615
 243  View(s)
Ratings:
Rate this:
  1. Post:123

    Points:615
    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.

Answer