Solution to Exercise 4

Solution to exercise 4.

We'll cover the following...

Solution

Press + to interact
SELECT MAX(SALARY) AS SECOND_HIGHEST
FROM SALARY
WHERE SALARY < (SELECT MAX(SALARY) FROM SALARY);

Again, the solution will work without the SECOND_HIGHEST alias. ...