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