List the Name of Employees who are taking the 2nd highest salary using SqlServer?

Below is the data which is present in a table

ID  Name  Salary
1    AAAA    10000
2    CCCC    5000
3    BBBB    5000
4   DDDD    3000
5    EEEE   3555

Sql Query:-select Name,salary from employee where salary=(select min(salary) from employee where salary in (select top 2 salary from employee order by salary desc))

OutPut:-
Name  Salary
CCCC  5000
BBBB  5000