Move to Sql Server 2012.

They have introduced OFFSET and FETCH

Example:

Select salary from table

order by salary desc

offset 1 row 'Start at 2nd row

fetch next 1 rows only 'show only the 2nd...