Second highest salary

1. METHOD

select max(salary) from emp where salary not in (select max(salary) from emp )

 2. METHOD ANY SALARY-- PUT NUMBER OF COUNT IN SUB-QUERY

SELECT TOP 1 Salary FROM ( SELECT TOP 5 Salary FROM emp ORDER BY Salary DESC)TEMP ORDER BY Salary