Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/lsp4you/public_html/connect.php on line 2 LSP4YOU - Learner's Support Publications

Select Query - 6

Q:11
Display the details of the employees arranged in the order of designation.


SQL> SELECT EMPNO, NAME, DESIGNATION FROM EMPLOYEE ORDER BY DESIGNATION;

     EMPNO NAME                      DESIGNATION
---------- ------------------------- --------------------
         4 JIJI JOHNSON              ACCOUNTATNT
         1 SAYAN                     MANAGER
         3 WILLAIMS                  MANAGER
         2 THOMAS KUTTY              SALESMAN
         5 MURUGAN R                 SENIOR MANAGER