With Limit
     SELECT salary FROM employee GROUP BY salary ORDER BY 
         salary DESC LIMIT 1,1;
With out Limit
     SELECT MAX(salary) FROM Employee WHERE Salary NOT IN
              ( SELECT Max(Salary) FROM Employee);                    
                

Comment