A subquery is a query that is nested within another subquery or within a SELECT, INSERT, UPDATE, or DELETE statement. The samples in this article make use of the AdventureWorks2016 database, which may be downloaded from the Adventure Works sample databases page. A subquery can be used wherever an expression is permitted.
Vishalini.R Answered question