Find the second highest wage in the Employee table SQL statement mnemonic

"Find employee records for the second highest wage in the employee table" How to write the SQL statement

This query first finds the highest wage, then excludes it from the list and then finds the highest wage. It was clear that the second return was the second highest wage.

Select top 1 * from employee where salary not int (select MAX (Salary) from Emplyee) Order BY salary DESC

Or

Select top 1 * FROM (SELECT top 2 * FROM employee ORDER BY salary desc) as-t order by salary ASC

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Find the second highest wage in the Employee table SQL statement mnemonic