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:7 Display the details of the employee with maximum Total. SQL> SELECT * FROM EMPLOYEE WHERE TOTAL=(SELECT MAX(TOTAL) FROM EMPLOYEE); EMPNO NAME DESIGNATION ---------- ------------------------- -------------------- DEPARTMENT BASICPAY DA TOTAL ------------------------- ---------- ---------- ---------- 5 MURUGAN R SENIOR MANAGER IT 60000 24000 84000