Select emp.name, emp.id, sal.salary from empDetai emp, 
empSal sal 
where emp.id=
  (select innnerEmp.id from 
   (select innerEmpSal.id, innerEmpSal.sal from empSal    
order        innerEmpSal.salary desc

    ) where rowid=2;

  )
And emp.id=sal.id;

This queiry initially execute the inner query and sort 
records based on the salary. second inner query returns the 
id of second maximum salary.

select emp.name,emp.id,sal.salary from empDetail emp,empSal
sal where sal.salary < (select max(salary) from empSal) and
emp.id=sal.id order by desc limit 1;