nswerWhich one is not a type of subquery ?OptionsSingle row sub queryCorrelated Sub queryMultiple row sub queryVariation based Sub query

Identifying the Non-Type of Subquery

1. Understanding Subqueries: In SQL, subqueries are queries nested inside other queries. Typically, they can be categorized as:

   • Single-row subquery: Returns a single row.
   • Correlated subquery: Depends on the outer query for its values.
   • Multiple-row subquery: Can return multiple rows.

2. Evaluating Options:

   • Single row subquery: A legitimate type of subquery.
   • Correlated subquery: A legitimate type of subquery.
   • Multiple row subquery: A legitimate type of subquery.
   • Variation based subquery: This is not a standardized type of subquery in SQL.

Final Answer

Variation based subquery is not a type of subquery.