Best Answer - Chosen by Asker

Solution: We can write a sub-query to achieve the result SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN (SELECT MAX(SALARY) FROM EMPLOYEE) The first sub-query [SELECT MAX(SALARY) FROM EMPLOYEE] in the WHERE clause will return the MAX SALARY in the table and the main query SELECT’s the MAX SALARY from the results which doesn’t have the highest SALARY.