We have an employee salary table how do we find the secondhighest from it | Eklavya Online

We have an employee salary table how do we find the secondhighest from it

Below Sql Query find the second highest salary

SELECT * FROM pcdsEmployeeSalary a WHERE (2=(SELECT COUNT(DISTINCT(b.salary)) FROM pcdsEmployeeSalary b WHERE b.salary>=a.salary))