SQL Server - Select where each row is numbered row count

Select misc_value, rank from (
Select misc_key, misc_value, rank() OVER (ORDER BY misc_key, misc_value) as rank
from mga_misc
)a
where rank = 5