Systango interview question
2 ways to write an sql query for second highest salary
Interview Answer
Anonymous
Sep 17, 2019
select max(salary) from tablename where salary NOT IN (select (max) salary from tablename);
1
2 ways to write an sql query for second highest salary
Anonymous
select max(salary) from tablename where salary NOT IN (select (max) salary from tablename);
Check out your Company Bowl for anonymous work chats.