A subquery is a SELECT query that returns a single value and is nested inside a SELECT, INSERT, UPDATE, ...
technet.microsoft.com