Select Unique

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"
FROM "table_name"

For example, to select all distinct stores in Table Store_Information,

Table Store_Information

store_nameSalesDate
Los Angeles$1500Jan-05-1999
San Diego$250Jan-07-1999
Los Angeles$300Jan-08-1999
Boston$700Jan-08-1999

we key in,

SELECT UNIQUE Sales FROM Store_Information

Result:

store_name
$1500
$250
$300
$700

Next: SQL ROUND Function