请上传宽度大于 1200px,高度大于 164px 的封面图片
    调整图片尺寸与位置
    滚轮可以放大缩小图片尺寸,按住图片拖动可调整位置,多余的会自动被裁剪掉
取消
baijiajun89757(uid:185082)
职业资格认证:FCA-FineReport | FCA-FineBI | FCA-业务分析理论
  • 比如左边这一列到行次到45    然后右边行次最上面又从46开始
  • select sum(GBAPYC/100), --年初数,sum(GBAN/100), --月份数合计,sum(GBAPYC/100+GBAN/100), --期末数,trim(GBOBJ)||trim(GBSUB) GBOBJGBSUB--trim(GBOBJ)||trim(GBSUB)from (select GBAPYC,GBOBJ,GBSUB,GBAID,GBCTRY,GBFY,GBCO,GBAN01 GBAN, 1 m FROM proddta.f0902union allselect 0 GBAPYC,GBOBJ,GBSUB,GBAID,GBCTRY,GBFY,GBCO,GBAN02 GBAN, 2 m FROM proddta.f0902union allselect 0 GBAPYC,GBOBJ,GBSUB,GBAID,GBCTRY,GBFY,GBCO,GBAN03 GBAN, 3 m FROM proddta.f0902union allselect 0 GBAPYC,GBOBJ,GBSUB,GBAID,GBCTRY,GBFY,GBCO,GBAN04 GBAN, 4 m FROM proddta.f0902union allselect 0 GBAPYC,GBOBJ,GBSUB,GBAID,GBCTRY,GBFY,GBCO,GBAN05 GBAN, 5 m FROM proddta.f0902union allselect 0 GBAPYC,GBOBJ,GBSUB,GBAID,GBCTRY,GBFY,GBCO,GBAN06 GBAN, 6 m FROM proddta.f0902union allselect 0 GBAPYC,GBOBJ,GBSUB,GBAID,GBCTRY,GBFY,GBCO,GBAN07 GBAN, 7 m FROM proddta.f0902union allselect 0 GBAPYC,GBOBJ,GBSUB,GBAID,GBCTRY,GBFY,GBCO,GBAN08 GBAN, 8 m FROM proddta.f0902union allselect 0 GBAPYC,GBOBJ,GBSUB,GBAID,GBCTRY,GBFY,GBCO,GBAN09 GBAN, 9 m FROM proddta.f0902union allselect 0 GBAPYC,GBOBJ,GBSUB,GBAID,GBCTRY,GBFY,GBCO,GBAN10 GBAN, 10 m FROM proddta.f0902union allselect 0 GBAPYC,GBOBJ,GBSUB,GBAID,GBCTRY,GBFY,GBCO,GBAN11 GBAN, 11 m FROM proddta.f0902union allselect 0 GBAPYC,GBOBJ,GBSUB,GBAID,GBCTRY,GBFY,GBCO,GBAN12 GBAN, 12 m FROM proddta.f0902)where GBCTRY = '${GBCTRY}' and GBFY = '${GBFY}' and GBCO = '${GBCO}'and m<='${GBAN}' --group by trim(GBOBJ)order by 4
  • 决策系统传参怎么排除这2个账号   Oracle数据库怎么写
  • 只是不知道 这种很多编号的情况下,内置数据集该怎么设置
  • 月份由于在字段里面已经给了出来,但是我需要把月份作为参数来当筛选项,因此不知道怎么设计SQL语句来把月份当作参数来当筛选项。还有一个问题就是如何把我拼接的字符串也作为参数。   SQL语句怎么写
  • 我这样写是错的
  • 如何在本地连接服务器的工作空间

36

30

36

10

个人成就
内容被浏览19,428
加入社区6年88天
返回顶部