What are sub query and its properties?

A sub-query is a query that can be nested inside the main query like Select, Update, Insert, or Delete statements. This can be used when the expression is allowed. Properties of sub query you can follow points

  1. sub query should be placed on the right-hand side of the comparison operator of the main query
  2. sub query should be enclosed in parenthesis because it needs to be executed first before the main query
  3. More than one sub query can be included
  4. sub query should not have order by clause

Leave a Comment