A subquery is a query that is nested inside a SELECT , INSERT , UPDATE , or DELETE statement, or inside another subquery. ... A subquery can be used anywhere an expression is allowed. In this example ...