接(主题:在线等!急 作者: yydy (游泳的鱼) )
yydy 2003-05-22 09:59:58 接(主题:在线等!急 作者: yydy (游泳的鱼) )
项目A
测点 日期 值
tadd tdate tval
c 2003-1-5 6.5
c 2003-1-5 2.8
c 2003-1-5 7.2
c 2003-1-6 6.5
c 2003-1-6 2.8
c 2003-1-6 7.2
c 2003-1-7 6.5
c 2003-1-7 2.8
c 2003-1-7 7.2
c 2003-1-8 6.5
c 2003-1-8 2.8
c 2003-1-8 7.2
c 2003-1-9 6.3
c 2003-1-9 9.8
c 2003-1-9 2.5
d 2003-1-5 4.3
d 2003-1-5 7.1
d 2003-1-5 4.3
d 2003-1-6 4.3
d 2003-1-6 7.1
d 2003-1-6 4.3
d 2003-1-7 4.3
d 2003-1-7 7.1
d 2003-1-7 4.3
项目B
测点 日期 值
tadd tdate tval
c 2003-1-5 6.5
c 2003-1-5 2.8
c 2003-1-5 7.2
c 2003-1-6 6.5
c 2003-1-6 2.8
c 2003-1-6 7.2
c 2003-1-7 6.5
c 2003-1-7 2.8
c 2003-1-7 7.2
c 2003-1-8 6.5
c 2003-1-8 2.8
c 2003-1-8 7.2
c 2003-1-9 6.3
c 2003-1-9 9.8
c 2003-1-9 2.5
d 2003-1-5 4.3
d 2003-1-5 7.1
d 2003-1-5 4.3
d 2003-1-6 4.3
d 2003-1-6 7.1
d 2003-1-6 4.3
d 2003-1-7 4.3
d 2003-1-7 7.1
d 2003-1-7 4.3
项目C
测点 日期 值
tadd tdate tval Pa Fx
c 2003-1-5 6.5 0 N
c 2003-1-5 2.8 0 N
c 2003-1-5 7.2 0 N
c 2003-1-6 6.5 0 NE
c 2003-1-6 2.8 0 NE
c 2003-1-6 7.2 0 NE
c 2003-1-7 6.5 0 S
c 2003-1-7 2.8 0 S
c 2003-1-7 7.2 0 S
c 2003-1-8 6.5 0 WS
c 2003-1-8 2.8 0 WS
c 2003-1-8 7.2 0 WS
c 2003-1-9 6.3 0 W
c 2003-1-9 9.8 0 W
c 2003-1-9 2.5 0 W
d 2003-1-5 4.3 0 N
d 2003-1-5 7.1 0 N
d 2003-1-5 4.3 0 N
d 2003-1-6 4.3 0 E
d 2003-1-6 7.1 0 E
d 2003-1-6 4.3 0 E
d 2003-1-7 4.3 0 WN
d 2003-1-7 7.1 0 WN
d 2003-1-7 4.3 0 WN
按月份统计
项目A 均值 项目B 均值 项目C 均值 Pa Fx
c 2003-1-5 6.3 4.8 7.2 6.1 6.3 4.8 7.2 6.1 6.3 4.8 7.2 6.1 0 N
c 2003-1-6 6.3 9.7 2.5 6.5 6.3 9.7 2.5 6.5 6.3 9.7 2.5 6.5 0 NE
c 2003-1-7 8.0 3.6 4.3 5.3 8.0 3.6 4.3 5.3 8.0 3.6 4.3 5.3 0 S
c 2003-1-8 6.3 9.7 2.5 6.5 6.3 9.7 2.5 6.5 6.3 9.7 2.5 6.5 0 WS
c 2003-1-9 8.0 3.6 4.3 5.3 8.0 3.6 4.3 5.3 8.0 3.6 4.3 5.3 0 W
均值 7 6 4.7 6 7 6 4.7 6 7 6 4.7 6 0 NULL
项目A 均值 项目B 均值 项目C 均值
d 2003-1-5 6.3 4.8 7.2 6.1 6.3 4.8 7.2 6.1 6.3 4.8 7.2 6.1 0 N
d 2003-1-6 6.3 9.7 2.5 6.5 6.3 9.7 2.5 6.5 6.3 9.7 2.5 6.5 0 E
d 2003-1-7 8.0 3.6 4.3 5.3 8.0 3.6 4.3 5.3 8.0 3.6 4.3 5.3 0 WN
均值 7 6 4.7 6 7 6 4.7 6 7 6 4.7 6 0 NULL
总平均值 7 6 4.7 6 7 6 4.7 6 7 6 4.7 6 0 NULL
各位能否就关键词或语句解释一下啊,谢谢了 我翻了三本书了,不大清楚
如:
select *,(select cast((sum(1)-0.5)/3 as int)+1 from #datatable where tdate<=tem.tdate and tadd=tem.tadd) lb
,1 as a into # from #datatable tem
单独一个#的含义
IDENTITY(int,1,1) id 意义用途
每个临时表的用途 解决这样问题的思路
真的很麻烦了
开两个帖子吧