---
title: "How to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?"  
description: "How to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?"  
author: "Chris Anderson"  
published: 2011-09-17  
updated: 2020-09-18  
canonical: https://www.mindstick.com/interview/1267/how-to-search-second-maximum-second-highest-salary-value-integer-from-table-employee-field-salary-in-the-manner-so-that-mysql-gets-less-load  
category: "mysql"  
tags: ["mysql"]  
reading_time: 1 minute  

---

# 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 ; \

## Answers

### Answer by Chris Anderson

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


---

Original Source: https://www.mindstick.com/interview/1267/how-to-search-second-maximum-second-highest-salary-value-integer-from-table-employee-field-salary-in-the-manner-so-that-mysql-gets-less-load

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.