Javatpoint Logo
Javatpoint Logo

Oracle DISTINCT Clause

Oracle DISTINCT clause is used to remove the duplicate records from the result set. It is only used with SELECT statement.

Syntax:

Parameters:

expressions:It specifies the columns that you want to retrieve.

tables: It specifies the table from where you want to retrieve records.

conditions: It specifies the conditions that must be fulfilled.

Oracle DISTINCT Example: (with single expression)

Let's take a table "customers"

Customer table:

Customer Table

Execute this query:

Output:

oracle distinct query 1

Oracle DISTINCT Example: (with multiple expressions)

Execute this query:

Output:

oracle distinct query 1

This example specifies distinct name, age and salary of the customer where age is greater than or equal to 65.

Next TopicOracle FROM Clause




Youtube For Videos Join Our Youtube Channel: Join Now

Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA