A subquery is a query that is nested inside a SELECT statement, an INSERT statement, a UPDATE statement, a DELETE statement, or inside another subquery. The AdventureWorks2016 database is used in the samples in this article and can be downloaded from AdventureWorks sample databases. Anywhere an expression is allowed, a subquery can be utilised.