DISTINCT CLAUSE:

  • The main purpose of using this distinct clause is to eliminates duplicates.

Syntax of  Distinct Clause : distinct <column>/<collist>

Example:  Select distinct job from emp

         Job

     Analyst

      Clerk

       Manager

       Salesman

Example:- Select distinct deptno, job from emp

Deptno                    job

10                           manager

10                           clerk

20                            manager

20                             hr

20                             clerk