Tech Mahindra Interview Question
Q.Write a Mysql query to find the second maximum salary from a table ?
Interview Answer
Anonymous
Aug 19, 2016
SELECT MAX(Salary) FROM Employee WHERE Salary NOT IN (SELECT MAX(Salary) FROM Employee )
Q.Write a Mysql query to find the second maximum salary from a table ?
Anonymous
SELECT MAX(Salary) FROM Employee WHERE Salary NOT IN (SELECT MAX(Salary) FROM Employee )
Check out your Company Bowl for anonymous work chats.