【PostGresql】------ pg多表数据多个条件汇总使用 union 方法示例代码

1. 示例代码如下：

SELECT
		"ID",
		"DT_DATE",
		"CNAME",
		"RMAN_NAME",
		"DEP_NAME",
		"DEP_ID",
		"INVEST_MAN_NAME",
		"TYPE_NAME",
		"INVEST_LEVEL_NAME",
		"POSITION_NAME",
		"CMEMO",
	  SUM ( "YHCOUNT" ) AS "YHCOUNT",
		SUM ( "YCCOUNT" ) AS "YCCOUNT",
		SUM ( "WCCOUNT" ) AS "WCCOUNT"

FROM
	(
		(
				SELECT
					"WR"."ID",
					"WR"."DT_DATE",
					"WR"."CNAME",
					"WR"."RMAN_NAME",
					"WR"."DEP_NAME",
					"WR"."DEP_ID",
					"WR"."INVEST_MAN_NAME",
					"WR"."TYPE_NAME",
					"WR"."INVEST_LEVEL_NAME",
					"WR"."POSITION_NAME",
					"WR"."CMEMO",
					COUNT ( "APT"."WR_ID" ) AS "YHCOUNT",
					0 AS "YCCOUNT",
					0 AS "WCCOUNT"
				FROM
					"DCS_WR" AS "WR"
					LEFT JOIN "DCS_ACCIDENT_POTENTIAL" AS "APT" ON "WR"."ID" = "APT"."WR_ID" 
				WHERE
					"WR"."BILL_TYPE" = '隐患排查记录' 
					AND "WR"."ORG_ID" = '23cffbbf076a49798171ea9afbc25330' 
					AND ( "WR"."DT_DATE" >= '2024-02-18' ) 
					AND ( "WR"."DT_DATE" <= '2024-03-20' ) 
				GROUP BY
					"WR"."ID",
					"WR"."DT_DATE",
					"WR"."CNAME",
					"WR"."RMAN_NAME",
					"WR"."DEP_NAME",
					"WR"."DEP_ID",
					"WR"."INVEST_MAN_NAME",
					"WR"."TYPE_NAME",
					"WR"."INVEST_LEVEL_NAME",
					"WR"."POSITION_NAME",
					"WR"."CMEMO" 
				
			) UNION
			(
				SELECT
					"WR"."ID",
					"WR"."DT_DATE",
					"WR"."CNAME",
					"WR"."RMAN_NAME",
					"WR"."DEP_NAME",
					"WR"."DEP_ID",
					"WR"."INVEST_MAN_NAME",
					"WR"."TYPE_NAME",
					"WR"."INVEST_LEVEL_NAME",
					"WR"."POSITION_NAME",
					"WR"."CMEMO",
					0 AS "YHCOUNT",
					COUNT ( "APT"."WR_ID" ) AS "YCCOUNT",
					0 AS "WCCOUNT"
				FROM
					"DCS_WR" AS "WR"
					LEFT JOIN "DCS_ACCIDENT_POTENTIAL" AS "APT" ON "WR"."ID" = "APT"."WR_ID" 
				WHERE
					"WR"."BILL_TYPE" = '隐患排查记录' 
					AND "WR"."ORG_ID" = '23cffbbf076a49798171ea9afbc25330' 
					AND ( "WR"."DT_DATE" >= '2024-02-18' ) 
					AND ( "WR"."DT_DATE" <= '2024-03-20' ) 
					and  ("APT"."STATUS_NAME"='已复查' or "APT"."STATUS_NAME"='待复查')
				GROUP BY
					"WR"."ID",
					"WR"."DT_DATE",
					"WR"."CNAME",
					"WR"."RMAN_NAME",
					"WR"."DEP_NAME",
					"WR"."DEP_ID",
					"WR"."INVEST_MAN_NAME",
					"WR"."TYPE_NAME",
					"WR"."INVEST_LEVEL_NAME",
					"WR"."POSITION_NAME",
					"WR"."CMEMO" 
				
			) 
			 UNION
			(
				SELECT
					"WR"."ID",
					"WR"."DT_DATE",
					"WR"."CNAME",
					"WR"."RMAN_NAME",
					"WR"."DEP_NAME",
					"WR"."DEP_ID",
					"WR"."INVEST_MAN_NAME",
					"WR"."TYPE_NAME",
					"WR"."INVEST_LEVEL_NAME",
					"WR"."POSITION_NAME",
					"WR"."CMEMO",
					0 AS "YHCOUNT",
					0 AS "YCCOUNT",
					COUNT ( "APT"."WR_ID" ) AS "WCCOUNT"
				FROM
					"DCS_WR" AS "WR"
					LEFT JOIN "DCS_ACCIDENT_POTENTIAL" AS "APT" ON "WR"."ID" = "APT"."WR_ID" 
				WHERE
					"WR"."BILL_TYPE" = '隐患排查记录' 
					AND "WR"."ORG_ID" = '23cffbbf076a49798171ea9afbc25330' 
					AND ( "WR"."DT_DATE" >= '2024-02-18' ) 
					AND ( "WR"."DT_DATE" <= '2024-03-20' ) 
					and  "APT"."STATUS_NAME"!='已复查' AND "APT"."STATUS_NAME"!='待复查'
				GROUP BY
					"WR"."ID",
					"WR"."DT_DATE",
					"WR"."CNAME",
					"WR"."RMAN_NAME",
					"WR"."DEP_NAME",
					"WR"."DEP_ID",
					"WR"."INVEST_MAN_NAME",
					"WR"."TYPE_NAME",
					"WR"."INVEST_LEVEL_NAME",
					"WR"."POSITION_NAME",
					"WR"."CMEMO" 
				
			) 
	) "T"
	

WHERE
	( 1 = 1 )   and ("YHCOUNT">0 OR "WCCOUNT">0 OR "YCCOUNT">0)

GROUP BY 
	
		"ID",
		"DT_DATE",
		"CNAME",
		"RMAN_NAME",
		"DEP_NAME",
		"DEP_ID",
		"INVEST_MAN_NAME",
		"TYPE_NAME",
		"INVEST_LEVEL_NAME",
		"POSITION_NAME",
		"CMEMO"
ORDER BY
	"DT_DATE" DESC

本文来自互联网用户投稿，该文观点仅代表作者本人，不代表本站立场。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如若转载，请注明出处：/a/483785.html

如若内容造成侵权/违法违规/事实不符，请联系我们进行投诉反馈qq邮箱809451989@qq.com，一经查实，立即删除！