Select Query - 4

Q:9
Display the Department wise listing of all employees in ascending order of name.


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

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