A subquery is a query that is used by the developers when the expressions are allowed and can be tested inside the actual query for e.g. SELECT, DELETE, UPDATE or INSERT statements.

Its properties are-
  • It cannot have any order true clause.
  • More than one of it can be included in the main query.
  • It has to be placed with parenthesis to get executed in first place.
  • It is the main query which has to be placed on the right-hand side of the comparison operator.
BY Best Interview Question ON 17 Oct 2019