Limiting the rows in a select statement for a specific condition is done by the clause
Distinct
Projection
Where
All of the above