Pergunta de entrevista da empresa Tech Mahindra

Q.Write a Mysql query to find the second maximum salary from a table ?

Resposta da entrevista

Sigiloso

19 de ago. de 2016

SELECT MAX(Salary) FROM Employee WHERE Salary NOT IN (SELECT MAX(Salary) FROM Employee )