SQL Select Unique - sql - sql tutorial - learn sql

SELECT UNIQUE is an old syntax which was used in oracle description but later ANSI standard defines DISTINCT as the official keyword.
After that oracle also added DISTINCT but did not withdraw the service of UNIQUE keyword for the sake of backward compatibility.
In simple words, we can say that SELECT UNIQUE statement is used to retrieve a unique or distinct element from the table.
The SELECT UNIQUE construct is an Oracle-only SQL statement. It is equivalent to SELECT DISTINCT.
The SELECT DISTINCT statement is used to return only distinct (different) values.
Inside a table, a column often contains many duplicate values; and sometimes you only want to list the different (distinct) values.
The SELECT DISTINCT statement is used to return only distinct (different) values.

Syntax

SELECT UNIQUE "column_name"
FROM "table_name";

To select all distinct stores in Table product_Information in Oracle, we key in,

SELECT UNIQUE Sales FROM product_Information;

For these exercises, assume we have a table called province _Sales with the following data:

province	Year	Orders	Total_Sales
West	2013	1560	325000
West	2014	1820	380000
North	2013	790	148000
North	2014	995	185000
East	2013	1760	375000
East	2014	2220	450000
South	2013	1790	388000
South	2014	1695	360000

SELECT UNIQUE province FROM province _Sales;

SELECT DISTINCT province FROM province _Sales;

SELECT DISTINCT Year FROM Region_Sales;

SELECT UNIQUE * FROM Region_Sales;

SELECT * FROM Region_Sales;

SELECT UNIQUE Year FROM Region_Sales;

SELECT UNIQUE Region FROM Region_Sales WHERE Orders < 1000;

REGION
North