Order by clause in Oracle

        It is the last clause of select statement responsible to arrange the records in a proper manner either ascending or descending order. To do so order by clause provides two attributes, asc and desc. The default order is asc.

Select empno, ename, sal, job, deptno from emp

Order by deptno desc;

(Single column wise ordering)

Select empno, ename , job, deptno from emp

Order by deptno, sal desc;