0

Please login or register to vote for this query.

(click on this box to dismiss)

Вопросы и ответы о сайте для программистов

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

fork query

edited may 18 12 anonymous

created may 18 12 Mikael Eriksson