How to find 2nd highest salary in employee table while working in sql ??

Question

Sql question

Answer 1

SELECT name, MAX(salary) AS salary
FROM employee
WHERE salary < (SELECT MAX(salary)
FROM employee);

Answer 2

select the salary column from employee table in desencending order by salary, then limit the result to 1 starting from the 2nd column

# its almost the answer