Solution to Exercise 4
Solution to exercise 4.
We'll cover the following...
Solution
Press + to interact
SELECT MAX(SALARY) AS SECOND_HIGHESTFROM SALARYWHERE SALARY < (SELECT MAX(SALARY) FROM SALARY);
Again, the solution will work without the SECOND_HIGHEST
alias. ...