select * from ( select bl.*,tc.TypeclassName, row_number() over(order by @@servername) as rownum from blogger as bl inner join Typeclass as tc on bl.bloggerid=tc.Typeclassid)a where rownum between 2 and 4
查询2到4条语句
原文：http://www.cnblogs.com/chengyuanbo/p/5477253.html