本帖最后由 zkody 于 2025-5-30 08:49 编辑
楼主，我看咱们把月份放到列上了，应该是想一条数据统计一月到十二月的借贷方发生额，可以写个视图加工下比如：
SELECT
ZWKMJE_KMBH AS 科目编号,
ZWKMJE_KJND AS 会计年度,
SUM(ZWKMJE_JFFS) AS 总借方发生额,
SUM(ZWKMJE_DFFS) AS 总贷方发生额,
SUM(CASE WHEN ZWKMJE_KJQJ = '01' THEN ZWKMJE_JFFS ELSE 0 END) AS 一月借方,
SUM(CASE WHEN ZWKMJE_KJQJ = '01' THEN ZWKMJE_DFFS ELSE 0 END) AS 一月贷方,
SUM(CASE WHEN ZWKMJE_KJQJ = '02' THEN ZWKMJE_JFFS ELSE 0 END) AS 二月借方,
SUM(CASE WHEN ZWKMJE_KJQJ = '02' THEN ZWKMJE_DFFS ELSE 0 END) AS 二月贷方,
SUM(CASE WHEN ZWKMJE_KJQJ = '03' THEN ZWKMJE_JFFS ELSE 0 END) AS 三月借方,
SUM(CASE WHEN ZWKMJE_KJQJ = '03' THEN ZWKMJE_DFFS ELSE 0 END) AS 三月贷方,
SUM(CASE WHEN ZWKMJE_KJQJ = '04' THEN ZWKMJE_JFFS ELSE 0 END) AS 四月借方,
SUM(CASE WHEN ZWKMJE_KJQJ = '04' THEN ZWKMJE_DFFS ELSE 0 END) AS 四月贷方,
SUM(CASE WHEN ZWKMJE_KJQJ = '05' THEN ZWKMJE_JFFS ELSE 0 END) AS 五月借方,
SUM(CASE WHEN ZWKMJE_KJQJ = '05' THEN ZWKMJE_DFFS ELSE 0 END) AS 五月贷方,
SUM(CASE WHEN ZWKMJE_KJQJ = '06' THEN ZWKMJE_JFFS ELSE 0 END) AS 六月借方,
SUM(CASE WHEN ZWKMJE_KJQJ = '06' THEN ZWKMJE_DFFS ELSE 0 END) AS 六月贷方,
SUM(CASE WHEN ZWKMJE_KJQJ = '07' THEN ZWKMJE_JFFS ELSE 0 END) AS 七月借方,
SUM(CASE WHEN ZWKMJE_KJQJ = '07' THEN ZWKMJE_DFFS ELSE 0 END) AS 七月贷方,
SUM(CASE WHEN ZWKMJE_KJQJ = '08' THEN ZWKMJE_JFFS ELSE 0 END) AS 八月借方,
SUM(CASE WHEN ZWKMJE_KJQJ = '08' THEN ZWKMJE_DFFS ELSE 0 END) AS 八月贷方,
SUM(CASE WHEN ZWKMJE_KJQJ = '09' THEN ZWKMJE_JFFS ELSE 0 END) AS 九月借方,
SUM(CASE WHEN ZWKMJE_KJQJ = '09' THEN ZWKMJE_DFFS ELSE 0 END) AS 九月贷方,
SUM(CASE WHEN ZWKMJE_KJQJ = '10' THEN ZWKMJE_JFFS ELSE 0 END) AS 十月借方,
SUM(CASE WHEN ZWKMJE_KJQJ = '10' THEN ZWKMJE_DFFS ELSE 0 END) AS 十月贷方,
SUM(CASE WHEN ZWKMJE_KJQJ = '11' THEN ZWKMJE_JFFS ELSE 0 END) AS 十一月借方,
SUM(CASE WHEN ZWKMJE_KJQJ = '11' THEN ZWKMJE_DFFS ELSE 0 END) AS 十一月贷方,
SUM(CASE WHEN ZWKMJE_KJQJ = '12' THEN ZWKMJE_JFFS ELSE 0 END) AS 十二月借方,
SUM(CASE WHEN ZWKMJE_KJQJ = '12' THEN ZWKMJE_DFFS ELSE 0 END) AS 十二月贷方,
MAX(ZWKMJE_NCYE) AS 年初余额,
MAX(ZWKMJE_DQYE) AS 期末余额
FROM
ZWKMJE
GROUP BY
ZWKMJE_KMBH, ZWKMJE_KJND
ORDER BY
ZWKMJE_KMBH, ZWKMJE_KJND;
|
陕公网安备：61019002000258 |
隐私政策 |
网站地图
