DISTINCT, DISTINCT ON (…) or ALL after SELECT.
DISTINCT
DISTINCT ON (…)
ALL
Readonly
The ON (…) expressions; empty unless the form is DistinctOn.
ON (…)
DistinctOn
DISTINCT,DISTINCT ON (…)orALLafter SELECT.