if you want to find third highest salary then SELECT salary FROM employee ORDER BY salary DESC LIMIT 2,1;

SELECT salary FROM employee ORDER BY salary DESC LIMIT 1,1; the easiest solution to find second highest salary of employee..