select id,revtime,
sum(case channel when 1 then val end)as channel1data,
sum(case channel when 2 then val end)as channel2data,
sum(case channel when 3 then val end)as channel3data
from Test2 group by id,revtime
select id,revtime,
sum(case channel when 1 then val end)as channel1data,
sum(case channel when 2 then val end)as channel2data,
sum(case channel when 3 then val end)as channel3data
from Test2 group by id,revtime