In this article, We’ll see how to find Second Highest Salary of Employee
We’ve created a employees table i.e tbl_employees and added some records inside table.
Query to find Second Highest Salary of Employee
SELECT MAX(salary) as second_highest_salary FROM `tbl_employees` WHERE salary < (SELECT MAX(salary) FROM `tbl_employees`)
That’s it!. Please share your thoughts or suggestions in the comments below.