Вопросы и ответы о сайте для программистов
declare @T table ( FirstColumn datetime primary key, S_E1 float ) insert into @T(FirstColumn, S_E1) values ('2012-01-01T00:00:01', 1), ('2012-01-01T00:00:02', 2), ('2012-01-01T00:00:03', 3), ('2012-01-01T00:00:04', 4), ('2012-01-01T00:00:05', 5), ('2012-01-01T00:00:06', 6) declare @Skip int = 2 declare @Take int = 2 select avg(S_E1),FirstColumn from ( select S_E1,FirstColumn, row_number() over(order by FirstColumn) as rn from @T ) T where rn > @Skip and rn <= @Skip + @Take group by S_E1,FirstColumn