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?

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 Anderson 2215 17-Sep-2011

mysql

Updated on 18-Sep-2020

Chris Anderson

Other

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

Message

Can you answer this question?

1 Answers

17-Sep-2011

SELECT DISTINCT(salary) FROM employee order by salary desc limit 1 , 1 ;

MindStick Training