(1) A form of a fullselect that is enclosed within parentheses and used as a component of a query.
(2) In SQL, a subselect used within a predicate. For example, a select-statement within the WHERE or HAVING clause of another SQL statement.