Select Query - 3

Q:8
Display the details of the employee with Total salary is greater than the average salary.


SQL> SELECT EMPNO,NAME, TOTAL FROM EMPLOYEE WHERE TOTAL > (SELECT AVG(TOTAL) FROM EMPLOYEE);

     EMPNO NAME                           TOTAL
---------- ------------------------- ----------
         1 SAYAN                          70000
         5 MURUGAN R                      84000