A subquery is a query embedded within another query in a database. It is enclosed in parentheses and retrieves data to be used by the main query. Subqueries can appear in various parts of a SQL statement and help create more complex and flexible queries.