select * from employee
select max(e_salary) from employee where e_salary not in (select max(e_salary) from employee)@sqlhub
DA Data Science. SQL hub @sqlhub · 36K subscribers 
select * from employee
select max(e_salary) from employee where e_salary not in (select max(e_salary) from employee)