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 ...

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 ...

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.

In situations in which you have multiple duplicate records in a table, it might make more sense to return only unique records, instead of fetching the duplicates. The SQL DISTINCT keyword is used in ...