Select name,salary from employee
Order by salary desc limit 1 offset 2.
When set offset 1 then return 2nd, set offset 2 then return 3rd highest salary.
Order by salary desc limit 1 offset 2.
When set offset 1 then return 2nd, set offset 2 then return 3rd highest salary.