fetch fourth maximum record from the table field
- by chetan
Following is the command to fetch maximum salary form empsalary table in mysql
select max(salary) from empsalary;
but I want to fetch employee who got fourth highest from the list of employee.
I don't want to use trigger or function because I know there is direct command to fetch.
