select * from (select row_number() over(order by id) as num, * from table) as t where t.num>=@start and t.num<=@end