DISTINCT and 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

 

 

 

Leave a comment

Your email address will not be published. Required fields are marked *