表一的结构及数据如下:
a c d e f i
f3001006698 f3036001 2003-10-5 112.3 0 200306
f3001006698 f3036001 2003-10-5 -112.3 0 200306
f3001006698 f3036001 2003-10-5 112.3 0 200306
f3001006698 f3036001 2003-10-5 21 0 200307
f3001006698 f3036001 2003-10-5 -21 0 200307
f3001006698 f3036001 2003-10-5 21 0 200307
f3001006698 f3036001 2003-10-5 16.7 0 200308
f3001006698 f3036001 2003-10-5 -16.7 0 200308
f3001006698 f3036001 2003-10-5 16.7 0 200308
f3100024334 f3027001 2003-10-6 39.31 5.54 200307
f3100024334 f3027001 2003-10-6 18 0.86 200308
f3100043641 f0000ds1 2003-10-2 58.16 1.84 200308
f3100044679 f3029001 2003-10-8 22.89 3.36 200307
f3100044679 f3029001 2003-10-8 32.61 1.76 200308
f3506462712 f3001005 2003-10-1 205.31 44.96 200306
f3506462712 f3001005 2003-10-1 37.3 4.7 200307
f3506462712 f3001005 2003-10-1 27 0.73 200308
表二的结构及数据如下:
a c d e f i ii iii
f3001006698 f3036001 2003-10-5 150 0 200306 200307 200308
f3100024334 f3027001 2003-10-6 57.31 6.4 200307 200308
f3100043641 f0000ds1 2003-10-2 58.16 1.84 200308
f3100044679 f3029001 2003-10-8 55.5 5.12 200307 200308
f3506462712 f3001005 2003-10-1 269.61 50.39 200306 200307 200308我怎么才能得到表二的结果呢?烦请高手指点一二 ^_^
a c d e f i
f3001006698 f3036001 2003-10-5 112.3 0 200306
f3001006698 f3036001 2003-10-5 -112.3 0 200306
f3001006698 f3036001 2003-10-5 112.3 0 200306
f3001006698 f3036001 2003-10-5 21 0 200307
f3001006698 f3036001 2003-10-5 -21 0 200307
f3001006698 f3036001 2003-10-5 21 0 200307
f3001006698 f3036001 2003-10-5 16.7 0 200308
f3001006698 f3036001 2003-10-5 -16.7 0 200308
f3001006698 f3036001 2003-10-5 16.7 0 200308
f3100024334 f3027001 2003-10-6 39.31 5.54 200307
f3100024334 f3027001 2003-10-6 18 0.86 200308
f3100043641 f0000ds1 2003-10-2 58.16 1.84 200308
f3100044679 f3029001 2003-10-8 22.89 3.36 200307
f3100044679 f3029001 2003-10-8 32.61 1.76 200308
f3506462712 f3001005 2003-10-1 205.31 44.96 200306
f3506462712 f3001005 2003-10-1 37.3 4.7 200307
f3506462712 f3001005 2003-10-1 27 0.73 200308
表二的结构及数据如下:
a c d e f i ii iii
f3001006698 f3036001 2003-10-5 150 0 200306 200307 200308
f3100024334 f3027001 2003-10-6 57.31 6.4 200307 200308
f3100043641 f0000ds1 2003-10-2 58.16 1.84 200308
f3100044679 f3029001 2003-10-8 55.5 5.12 200307 200308
f3506462712 f3001005 2003-10-1 269.61 50.39 200306 200307 200308我怎么才能得到表二的结果呢?烦请高手指点一二 ^_^
解决方案 »
- AdvStringGrid 单元格合并之后数据为什么只是横向居中呢?
- [怎么修改这个错误Error] test.pas(36): Not enough actual parameters
- 在使用IP的WWDBGrid的CheckBox,运行后怎么也显示不了打钩呢。。。。。怎么办????
- 跪求三层系统源码
- dxDBTreeView展开后..如何..回到顶部.
- 我想请问一下有没有哪位知道在哪里可以免费下载到delphi第三方控件
- 单据报表制作遇到大麻烦!!!!
- IMAGE
- 如何打印条形码????
- 关于排考号的问题,有人会吗?
- 数据保存处理的问题!
- 请问高手开发一个这样的软件要多少钱?? 急~~~~
结构为 a,c,d,e,f,i,ii,iii,.....iiiiiiii
第一步,插入数据。
insert into Temp(a,c,d,e,f)
select a,c,d,sum(e),sum(f) from 表一
group by a,c,d
第二步,更新年月。
对应的在临时表中查找数据a,c,d.然后对应在表一中查找有几个年月,然后在更新到临时表中
SELECT 表1.a,表1.c,表1.d,表1.e,表1.f,表1.i,' ' as ii,' 'as iii
union
SELECT 表2.a,表2.c,表2.d,表2.e,表2.f,表2.i,表2.ii,表2.iii
select 表1.列......unionselect 表2.列
但是到底临时表Temp要加多少列不太好确定。bestluo(要学)的也是一种方法,可能还简单些