1. To find exact second salary
select max(salary) from jos_emp where salary < (select max(salary) from jos_emp)
2. To find all second salary
select salary from jos_emp where salary=(select max(salary) from jos_emp where salary < (select max(salary) from jos_emp)).
select max(salary) from jos_emp where salary < (select max(salary) from jos_emp)
2. To find all second salary
select salary from jos_emp where salary=(select max(salary) from jos_emp where salary < (select max(salary) from jos_emp)).