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
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