Second highest salary

SELECT top 1 emp_salary FROM (SELECT top 2 emp_salary FROM EmployeeInfo ORDER BY emp_salary DESC) a ORDER BY emp_salary ASC

SELECT  MAX(emp_salary) FROM EmployeeInfo WHERE emp_salary <   (SELECT MAX(emp_salary) FROM EmployeeInfo)

SELECT emp_salary FROM ( SELECT emp_salary,
ranking=DENSE_RANK() OVER(ORDER BY emp_salary DESC)
FROM EmployeeInfo) a WHERE a.ranking=2