Pregunta de entrevista en CMSS Private Limited: 1.find second max salary hint using count

CMSS Private Limited

1.find second max salary hint using count

Anónimo

12 de jul de 2018

SELECT max(salary) FROM emptable WHERE salary < (SELECT max(salary) FROM emptable);

Anónimo

12 de jul de 2018

SELECT max(salary) FROM emptable WHERE salary < (SELECT max(salary) FROM emptable);

Anónimo

14 de jun de 2016

select max(Emp_Sal) from Employee a where 1 = ( select count(*) from Employee b where b.Emp_Sal > a.Emp_Sal)

Anónimo

13 de ago de 2015

select max(salary) from table where salary 1;