Keywordio interview question
Mysql query for second highest salary ?
Interview Answer
Anonymous
Jul 30, 2020
select max(salary) from employee where salary<(Select max(salary) from employee);
Mysql query for second highest salary ?
Anonymous
select max(salary) from employee where salary<(Select max(salary) from employee);
Check out your Company Bowl for anonymous work chats.