6.2.7 The #:distinct clause

The #:distinct clause allows you to filter query the results for unique results. It is the equivalent of the DISTINCT or DISTINCT ON clauses in SQL.

Tor consistent results across all DBMSs, the query must be sorted such that rows are returned in a deterministic order, with similar rows adjacent to one another in the result set.

The #:distinct clause may be one of the following values: