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