Finding the 2 nd Highest salary in Sql server

USE Mydb
GO

--creating the table

CREATE TABLE EMP
(
ID INT IDENTITY(1,1)
CONSTRAINT PK_EMP_ID  PRIMARY KEY,
NAME VARCHAR(30) NOT NULL,
SALARY MONEY
)
------To view the structure of the table


SELECT * FROM EMP

----Insert the records into the table

INSERT INTO EMP VALUES ('PRAMOD',12000),
('HARISH',15000),
('NARENDRA',20000),
('KRISHNA',15000),
('KIRAN',23000),
('RAMU',16000)

----FINDING THE TOP 2 nd Highest salary 
SELECT TOP 1  *
FROM EMP WHERE SALARY IN( SELECT TOP 2 SALARY
FROM EMP
ORDER BY 1 DESC)
ORDER BY SALARY asc

-----TOP 4 TH SALARY 

SELECT TOP 1  *
FROM EMP WHERE SALARY IN( SELECT TOP 4 SALARY
FROM EMP
ORDER BY 1 DESC)
ORDER BY SALARY asc