---

---

SQL SELECT DISTINCT Statement :

1. Suppose we need all the rows that are unique then we need to use distinct statement.
2. Sometimes column may contain the duplicate values then we can select only distinct values.
3. The DISTINCT keyword can be used to return only distinct (different) values.

Syntax :

SQL> SELECT DISTINCT column_name,column_name FROM table_name;

Select distinct rows :

Consider following “CUSTOMER” table –

Now suppose we want only addresses that are unique then we can use following query –

SQL> Select distinct ADDRESS from CUSTOMER

Program will give following output –

---

---