SQL SELECT UNIQUE
SQL > SQL Commands >
The SELECT UNIQUE construct is an Oracle-only SQL statement. It is equivalent to SELECT DISTINCT.
The syntax for SELECT UNIQUE is as follows:
SELECT UNIQUE "column_name"
We use the following table for our example.
To select all distinct stores in Table Store_Information in Oracle, we key in,
SELECT UNIQUE Sales FROM Store_Information;
For these exercises, assume we have a table called Region_Sales with the following data:
1. (True or False) The following two statements are equivalent in MySQL:
2. Which of the following statements are valid in Oracle?
3. What is the output for the following statement?