日期:2014-05-17  浏览次数:20828 次

一个取数问题

SQL code
  CREATE TABLE TAE_BDZH_TJ(F_ZHZDHSHL varchar2(20), F_ZHZDHBL varchar2(20), F_WGBCHRL varchar2(20), F_WGBCHBL varchar2(20), F_NUM varchar2(20),
  F_FQ varchar2(20), F_DYDJ varchar2(20), F_BDZHSHL varchar2(20), 
  F_ZHBTSH varchar2(20), F_RL varchar2(20), F_WRZHBSHL varchar2(20), F_WRZHBBL varchar2(20), CONSTRAINT PKEY PRIMARY KEY (F_NUM))
insert into tae_bdzh_tj values('2','100','0','0',299,'从化','220','2','4','660','2','100');
insert into tae_bdzh_tj values('13','100','0','0',300,'^UP','110','13','23','714.5','13','100');
insert into tae_bdzh_tj values('15','100','0','0',301,'^UP','小计','15','27','1374.5','15','100');
insert into tae_bdzh_tj values('1','100','0','0',302,'花都','500','1','2','3000','1','100');
insert into tae_bdzh_tj values('3','100','0','0',303,'^UP','220','3','6','1020','3','100');
insert into tae_bdzh_tj values('21','100','0','0',304,'^UP','110','21','41','1640','21','100');
insert into tae_bdzh_tj values('25','100','0','0',305,'^UP','小计','25','49','5660','25','100');
insert into tae_bdzh_tj values('3','100','0','0',306,'增城','220','3','7','1200','3','100');
insert into tae_bdzh_tj values('29','100','0','0',307,'^UP','110','29','63','2454.5','29','100');
insert into tae_bdzh_tj values('32','100','0','0',308,'^UP','小计','32','70','3654.5','32','100');
insert into tae_bdzh_tj values('1','100','0','0',309,'番禺','500','1','2','2000','1','100');
insert into tae_bdzh_tj values('7','100','0','0',310,'^UP','220','7','16','3420','7','100');
insert into tae_bdzh_tj values('39','100','0','0',311,'^UP','110','39','92','4161','39','100');
insert into tae_bdzh_tj values('47','100','0','0',312,'^UP','小计','47','110','9581','47','100');
insert into tae_bdzh_tj values('5','100','0','0',313,'荔湾','220','5','10','1860','5','100');
insert into tae_bdzh_tj values('12','100','0','0',314,'^UP','110','12','26','1129','12','100');
insert into tae_bdzh_tj values('17','100','0','0',315,'^UP','小计','17','36','2989','17','100');
insert into tae_bdzh_tj values('2','100','0','0',316,'海珠','220','2','6','1080','2','100');
insert into tae_bdzh_tj values('6','100','0','0',317,'^UP','110','6','14','626','6','100');
insert into tae_bdzh_tj values('8','100','0','0',318,'^UP','小计','8','20','1706','8','100');
insert into tae_bdzh_tj values('8','100','0','0',319,'越秀','110','8','22','946','8','100');
insert into tae_bdzh_tj values('8','100','0','0',320,'^UP','小计','8','22','946','8','100');
insert into tae_bdzh_tj values('3','100','0','0',321,'天河','220','3','9','1620','3','100');
insert into tae_bdzh_tj values('11','100','0','0',322,'^UP','110','11','30','1519','11','100');
insert into tae_bdzh_tj values('14','100','0','0',323,'^UP','小计','14','39','3139','14','100');
insert into tae_bdzh_tj values('1','100','0','0',324,'黄埔','220','1','2','300','1','100');
insert into tae_bdzh_tj values('5','100','0','0',325,'^UP','110','5','12','500','5','100');
insert into tae_bdzh_tj values('6','100','0','0',326,'^UP','小计','6','14','800','6','100');
insert into tae_bdzh_tj values('1','100','0','0',327,'萝岗','500','1','3','2250','1','100');
insert into tae_bdzh_tj values('2','100','0','0',328,'^UP','220','2','5','960','2','100');
insert into tae_bdzh_tj values('6','100','0','0',329,'^UP','110','6','14','600','6','100');
insert into tae_bdzh_tj values('9','100','0','0',330,'^UP','小计','9','22','3810','9','100');
insert into tae_bdzh_tj values('1','100','0','0',331,'白云','500','1','3','2250','1','100');
insert into tae_bdzh_tj values('9','100','0','0',332,'^UP','220','9','20','4020','9','100');
insert into tae_bdzh_tj values('24','100','0','0',333,'^UP','110','24','58','2322.6','24','100');
insert into tae_bdzh_tj values('34','100','0','0',334,'^UP','小计','34','81','8592.6','34','100');
insert into tae_bdzh_tj values('4','100','0','0',335,'小计','500','4','10','9500','4','100');
insert into tae_bdzh_tj values('37','100','0','0',33