coolingpipe(冷箫轻笛)还要麻烦你:)
insert into b
select top 1 datepart(hh,dateandtime) as dateandtime,
val1 = (select val from a where dateandtime = t1.dateandtime and tagindex = 1),
val3 = (select val from a where dateandtime = t1.dateandtime and tagindex = 3),
val4 = (select val from a where dateandtime = t1.dateandtime and tagindex = 4)
from a t1
--where datediff(hh,DateAndTime,getdate())=1
group by dateandtime
order by sum(val) desc
这个不是查找上一个小时的数据,我在数据库用这句查询的时候它在所有的数据里面查找