10 Second Highest Salary of Employee

SELECT * FROM employee E1
WHERE 1 = ( SELECT COUNT( DISTINCT salary )
 FROM employee E2
 WHERE E1.salary < E2.salary
  )
   LIMIT 0,10