Select Query - 1

Q:6
Display the EmpNo, Name of the employee with minimum Total.


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

     EMPNO NAME
---------- -------------------------
         2 THOMAS KUTTY