Dynamic Ranking - Examples

SELECT
*
FROM (
        SELECT [DurationInHours],(DENSE_RANK()
OVER
            (ORDER
BY [DurationInHours] DESC)) AS rnk
        FROM FactTimetrack
        )
AS A
WHERE A.rnk = 6