interview

Home / DeveloperSection / Interviews / How to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?

Ask Question

How to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?

Chris Anderson187817-Sep-2011
mysqlmysql 
Updated on 18-Sep-2020
Chris Anderson

Chris Anderson

Follow
hi I am software developer at mindstick software pvt. ltd.

Can you answer this question?

Answer

1 Answers

Chris Anderson

Chris Anderson

17-Sep-2011
SELECT DISTINCT(salary) FROM employee order by salary desc limit 1 , 1 ;

Liked By