How to get second highest or nth maximum salary of an Employee table is one of the most frequently asked Mysql/SQL interview question.
PHP Mysql Query
Suppose we have the following simple database table called Employee that has 3 columns named Employee ID,Employee Name and Salary:
Employee
##########################################
Employee_ID —– Employee_Name ——- Salary
1: —————– Avanish——— ——- 1000
2: —————– Abhishek——- ——- 1500
3:———...