Select Query - 5

Q:10
Display the Department wise listing of all employees in descending order of name.


SQL> SELECT DEPARTMENT,NAME FROM EMPLOYEE ORDER BY DEPARTMENT,NAME DESC;

DEPARTMENT                NAME
------------------------- -------------------------
ACCOUNTS                  JIJI JOHNSON
FINANCE                   SAYAN
IT                        MURUGAN R
SALES                     WILLAIMS
SALES                     THOMAS KUTTY