Actually, there is no difference between DISTINCT and UNIQUE.
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 the select statement used to query or retrieve data from a table in the database.
Let’s see the syntax of select unique statement.
- SELECT UNIQUE column_name
- FROM table_name;