Second Highest Salary in MYSQL
employees table:
| id | name | salary |
| 1 | mahendra | 1000 |
| 2 | shivam | 500 |
| 3 | deepak | 300 |
| 4 | rahul | 2000 |
Query-1:
SELECT MAX(salary)
FROM employees
WHERE salary < (SELECT MAX(salary) FROM employees);Query-2:
SELECT salary
FROM employees
ORDER BY salary DESC
LIMIT 1, 1;Output:
1000