Query to get the second highest salary of an employee in DB testing.

• Use the SELECT statement to retrieve the salary column from the employee table.

• Order the results in descending order using the ORDER...read more

select * from (select employee11.*, dense_rank() over (order by esal desc)  as ranking  from employee11 ) where ranking=2

select * from Employee_table where salary = (select min(salary) from Empoyee_table where salary in (select distinct top 2 from Employee_Table order by salary desc))