MYSQL query to find second highest salary

MYSQL query to get the second highest salary?.Most of the php interview this is the first question in mysql.So lets see below example which gives you a some idea about to get second highest salary in mysql.

To create a Table

mysql-query-to-find-second-largest-salary

Here we’re going to see about “How to get second highest salary in a table” using sql query.

Below is simple query to find the employee whose salary is highest.

Option 1:

Option 2:

Option 3:

Hope you get some idea about get second highest salary in mysql.

Happy Coding.