Subqueries that are introduced with unmodified comparison operators often include the distinct keyword to ensure the return of a single value.
For example, without distinct, this subquery would fail because it would return more than one value:
select pub_name from publishers
where pub_id =
(select distinct pub_id
from titles
where pub_id = publishers.pub_id)
