SQL SELECT UNIQUE
SQL > SQL Commands >
The SELECT UNIQUE term is an Oracle-only SQL statement. It is equivalent to SELECT DISTINCT. The syntax for SELECT UNIQUE is as follows:
SELECT UNIQUE "column_name"
For example, to select all distinct stores in Table Store_Information,
we key in,
SELECT UNIQUE Sales FROM Store_Information;