Query to retrieve all second highest salary employee records

Query to retrieve all second highest salary employee records
-------------------------------------------------------------
select * from employee where salary=(select max(salary) from employee where salary < (select max(salary) from employee));