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

Total Post:197

Points:985
Posted by  Chris Anderson
MYSQL 
 1228  View(s)
Ratings:
Rate this:
  1. Chris Anderson

    Post:197

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

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

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!