DECLARE @test TABLE(Empnm VARCHAR(10), Salary VARCHAR(10))

INSERT INTO @test (Empnm, Salary ) 
SELECT 'A', '200'
UNION ALL 
SELECT 'B', '300'
UNION ALL 
SELECT 'A', '200'
UNION ALL 
SELECT 'B', '300'
UNION ALL 
SELECT 'C', '400'
UNION ALL 
SELECT 'C', '400'
UNION ALL 
SELECT 'E', '100'
UNION ALL 
SELECT 'D', '500'

SELECT * FROM @test 


SELECT Empnm, Salary, (SELECT COUNT(DISTINCT(SALARY)) FROM
@test AS B WHERE A.Salary <= B.SALARY) 
FROM   @test AS A
GROUP BY Empnm, Salary 
HAVING 4 = (SELECT COUNT(DISTINCT(SALARY)) FROM @test AS B
WHERE A.Salary <= B.SALARY)

Create Table 'Employee' with columns 'Emp_Name' 
and 'Salary'. And, Insert some data.....

Cursor:
declare Cursor_Name cursor scroll
for select salary from Emploee order by salary desc
open Cursor_Name
fetch absolute 2 from Cursor_Name
deallocate Cursor_Name

Am Sumathy the above answer was posted by me.

For the above Answer 'absolute 2' will fetch 2nd maximum 
value.

To fetch 4th maximum value use 'absolute 4'
To fetch 'n'th maximum value use 'absolute n'

select payout,emp_cd from empmas e where 2>(select count(payout) from empmas s where s.payout>e.payout);

select * from (select *,row_number()over (order by salary
asc)as a from Employee)as b where b.a=4