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