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?

Posted on    September-17-2011 1:49 AM

 1 Answer(s)
  1074  View(s)
Rate this:

Chris Anderson
Chris Anderson

Total Post:197

Posted on    September-17-2011 12:00 AM

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

Don't want to miss updates? Please click the below button!

Follow MindStick