To suppress duplicates in a SELECT statement both clauses DISTINCT and UNIQUE can be used, though only DISTINCT is mentioned more widely than UNIQUE.
Both clauses are valid and work. ( see below )
DISTINCT
UNIQUE
To suppress duplicates in a SELECT statement both clauses DISTINCT and UNIQUE can be used, though only DISTINCT is mentioned more widely than UNIQUE.
Both clauses are valid and work. ( see below )
DISTINCT
UNIQUE