sql解析，日期 trunc sysdate

菜鸡且互啄69

于 2025-06-15 22:21:09 发布

阅读量252

点赞数 4

CC 4.0 BY-SA版权

文章标签： sql 数据库

本文链接：https://blog.csdn.net/2201_75600005/article/details/148675504

SELECT jh rpc,hs rhs,(SELECT SUM(jh) AS total_hs
        FROM aqks.aa_scyj
        WHERE rq >= TRUNC(SYSDATE, 'MM')  -- 本月第一天
        AND rq &lt; TRUNC(SYSDATE) AND dwdm = #{dwdm} ) ypc,
        (SELECT SUM(hs) AS total_hs
        FROM aqks.aa_scyj
        WHERE rq >= TRUNC(SYSDATE, 'MM')  -- 本月第一天
        AND rq &lt; TRUNC(SYSDATE) AND dwdm = #{dwdm} ) yhs,
        (SELECT avg(njh) AS total_hs
        FROM aqks.aa_scyj
        WHERE rq >= TRUNC(SYSDATE, 'YYYY')  -- 本年第一天
        AND rq &lt; TRUNC(SYSDATE) AND dwdm = #{dwdm} ) npc,
        (SELECT SUM(hs) AS total_hs
        FROM aqks.aa_scyj
        WHERE rq >= TRUNC(SYSDATE, 'YYYY')  -- 本年第一天
        AND rq &lt; TRUNC(SYSDATE) AND dwdm = #{dwdm} ) nhs,
        nsy,nlhs - nsy AS ncz,jh - hs AS ycz FROM  aqks.aa_scyj WHERE rq = to_date(#{rq},'yyyy-MM-dd') AND dwdm = #{dwdm}

TRUNC(SYSDATE, 'MM') ：