CREATE TABLE EmployeeTable

(

    Employee_ID INT IDENTITY(1,1),

    Employee_Name VARCHAR(128),

    Employee_Salary NUMERIC(19,2)

    PRIMAY_KEY (Employee_ID)

)

​

​

create procedure proc1

as

BEGIN

​

;WITH CTE AS(

SELECT ROW_NUMBER() OVER(ORDER BY Salary DESC) RN, Employee_Name, Employee_Id, Salary From EmployeeTable 

)

SELECT * FROM CTE WHERE Rn = 2

​

END