select * from (select row_number() over(order by id) as num, * from table) as t where t.num>=@start and t.num<=@end
sql分页
原文：http://www.cnblogs.com/hllive/p/5932033.html
