CMSS Private Limited Interview Question: 1.find second max salary hint using count

Notifications

CMSS Private Limited

1.find second max salary hint using count

Anonymous

12 Jul 2018

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

Anonymous

12 Jul 2018

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

Anonymous

14 Jun 2016

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

Anonymous

13 Aug 2015

select max(salary) from table where salary 1;