a select statement that selects a subset of fields in a table a select statement that returns a subset of the data in a table a select statement that appears within another select statement a select statement that returns a subset of the constraints on a field