Subquery

A query nested within other SQL statements, such as SELECT, INSERT, UPDATE or DELETE.