CREATE TABLE tmp(iCol INT identity(1,1), some_col varchar(10))GOINSERT tmp(some_col) SELECT 'a' GO 100DELETE FROM tmp WHERE iCol % 3 = 0GOSELECT TOP 5 * FROM tmp ORDER BY iCol DescGOWITH cte(a) AS ( SELECT TOP 5 iCol FROM tmp ORDER BY iCol Desc)SELECT TOP 1 a FROM cte ORDER BY aGOSELECT TOP 1 f.iCol FROM ( SELECT TOP 5 iCol FROM tmp ORDER BY iCol Desc) f ORDER BY f.iCol GODROP TABLE tmpGO