• oracel查询最会一行添加合计 IT


    SELECT t."NAME",t."YEAR",t."MONTH",t."REMARK",t."ID_CARD",GWGZ,JSGZ,BLBT,TSJT,ZFBT,BFGZ,YFGZ,KYLBX,KZYNJ,KZFGJJ,KYILBX,
    KGRSDS,KKHJ,SFGZ,JWJT,SHBT,DQFJJTHJ,GGXBT,GWJTBT,HJ,KZFGJJhj,seygwgz,seyjsgz,heng from V_T_WAGE_STANDARD t  where 1 = 1
                       and NAME like '%--%'
                       and to_char(enter_time, 'yyyy-MM') >= '2020-12'
                       and to_char(enter_time, 'yyyy-MM') <= '2020-12'
    UNION all
    SELECT '合计','','','','',sum(GWGZ) GWGZ, sum(JSGZ) JSGZ,sum(BLBT) BLBT,sum(tsjt) TSJT,sum(ZFBT) ZFBT, sum(bfgz) BFGZ,sum(YFGZ) YFGZ,
           sum(KYLBX) KYLBX, sum(KZYNJ) KZYNJ,sum(KZFGJJ) KZFGJJ,sum(KYILBX) KYILBX, sum(KGRSDS) KGRSDS,sum(KKHJ) KKHJ, sum(SFGZ) SFGZ,
           sum(JWJT) JWJT,sum(SHBT) SHBT,sum(DQFJJTHJ) DQFJJTHJ,sum(GGXBT) GGXBT,sum(GWJTBT) GWJTBT,
           sum(HJ) HJ,sum(KZFGJJhj) KZFGJJhj,sum(seygwgz) seygwgz,sum(seyjsgz) seyjsgz,sum(heng) heng from V_T_WAGE_STANDARD
           where 1 = 1
                       and NAME like '%--%'
                       and to_char(enter_time, 'yyyy-MM') >= '2020-12'
                       and to_char(enter_time, 'yyyy-MM') <= '2020-12'

  • 相关阅读:
    IDEA效率快捷键
    常用文件/文件夹操作
    git log状态下退出方法
    ImageList 构造函数
    ImageList 控件
    【转】图像分割代码合集
    【转】图像分割论文及代码资源汇总
    SLIC 算法
    c/c++内存分配详解
    c++内存分配
  • 原文地址:https://www.cnblogs.com/qxqbk/p/14345573.html
Copyright © 2020-2023  润新知