select*from (select row_number() over(orderby id) as[rows], *fromtable) as t where t.[rows]>=@startand t.[rows]<=@end
