The solution proposed used a nested select, why not using the limit offset like this?
SELECT Salary as SECOND_HIGHEST from SALARY order by salary desc limit 1 offset 1;
Yeah, we can use the offset method also to solve this database problem because there might be multiple methods to solve a problem.