Basically unique and distinct both are same means both do the same work , unique statement was used earlier by the oracle database but now a days distinct statement is using by the oracle ( now it is ...

Learn how to master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier.

The SELECT DISTINCT statement is used to return only unique (distinct) values from a column or set of columns in a table. Useful when a column contains duplicate values and you want to list only the ...