You can use subqueries to filter your data. A subquery answers a specific question or provides specific information within the context of a main query, also called a “parent” statement. The database evaluates the entire query by first analyzing the subquery. The parent statement filters its rows based on the rows retrieved by the subquery.