---

Oracle Distinct Clause

The Oracle DISTINCT clause is used to eliminate duplicate records from the table and retrieve only unique records. The Oracle DISTINCT clause is used with the SELECT statement only.

Oracle DISTINCT CLAUSE Syntax

To retrieve only unique records from existing table, use the following syntax:

Parameters:

tablename: The table name from which you want to remove all records.

DISTINCT: To eliminate duplicate records.

Note:

If DISTINCT clause is used with single field, the query will return the unique values for that field only.

If DISTINCT clause is used with multiple fields, the query will retrieve unique combinations for the expressions listed.

Oracle DISTINCT CLAUSE example with single field

The following Oracle statement to retrieve single field with unique records from "tblCustomer" table:

Note:

In the above example, we have fetched unique "address" from "tblCustomerLoan"

Show DISTINCT CLAUSE Example with NULL value

To retrieve unique records for NULL value, Oracle keeps one NULL value and eliminates the other because the DISTINCT clause treats all NULL values as the same value, use the following syntax:

---

---