Glossary: SQL Beyond the Basics

Subquery

Also written: subqueries

A complete SELECT in parentheses inside another query. It can give one value, one column of values, or a whole table.