Oracle Distinct | Oracle Distinct Clause - oracle tutorial - sql tutorial
![Oracle distinct](https://wikitechy.com/tutorials/oracle/img/oracle-images/oracle-distinct.gif)
Learn oracle - oracle tutorial - Oracle distinct - oracle examples - oracle programs
What is data manipulation language (DML) ?
- Oracle DISTINCT clause is used to remove the duplicate records from the result set.
- It is only used with SELECT statement.
![Oracle distinct order by clause](https://wikitechy.com/tutorials/oracle/img\oracle-images\sql-orderby.png)
Oracle distinct order by clause
Syntax
SELECT DISTINCT expressions
FROM tables
WHERE conditions;
click below button to copy the code. By - oracle tutorial - team
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 tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , plsql
Oracle DISTINCT Example: (with single expression)
- Let's take a table "customers"
Customer table
CREATE TABLE "CUSTOMERS"
( "NAME" VARCHAR2(4000),
"AGE" NUMBER,
"SALARY" NUMBER,
"STATE" VARCHAR2(4000)
)
/
click below button to copy the code. By - oracle tutorial - team
![customer table](https://wikitechy.com/tutorials/oracle/img\oracle-images\cust-table.png)
Execute this query
SELECT DISTINCT state
FROM customers
WHERE name = 'charu';
click below button to copy the code. By - oracle tutorial - team
Output:
![single expressions output](https://wikitechy.com/tutorials/oracle/img\oracle-images\distinct-single-output.png)
Oracle DISTINCT Example: (with multiple expressions)
Execute this query
SELECT DISTINCT name, age, salary
FROM customers
WHERE age >= '60';
click below button to copy the code. By - oracle tutorial - team
Output:
![multiple expressions output](https://wikitechy.com/tutorials/oracle/img\oracle-images\distinct-multiple-output.png)
- This example specifies distinct name, age and salary of the customer where age is greater than or equal to 65.