引自 宝玉的blog :
select threadid from ( select threadid, ROW_NUMBER() OVER (order by stickydate) as Pos from cs_threads) as T where T.Pos > 100000 and T.Pos < 100030
不仅支持row_number(), SQL Server 2005还支持rank(), dense_rank()