sql

3 minutes read
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:———...