Page 8 - Simple Queries in SQL
P. 8

Sorting output

                     Sorting Output –
                       Order by clause (ASC/DESC)
                       Select ename, hiredate
                       from emp
                       where deptno = 20
                       order by hiredate desc;
                       Select deptno, ename
                       from emp
                       order by deptno desc, ename;
                       (Note: default is ASC)
   3   4   5   6   7   8   9   10