How to display the employee number and name for employee working as clerk and earning highest salary among clerks?
SELECT empno, enameFROM empWHERE job=’CLERK’AND sal = (SELECT MAX(sal) FROM emp WHERE job=’CLERK’ );