【PostGresql】------PG两个字段数据相除保留两数小数查询

皮皮冰要做大神

于 2025-04-15 13:37:41 发布

阅读量250

点赞数 2

文章标签： postgresql 数据库 java

本文链接：https://blog.csdn.net/qq_38366657/article/details/147248149

版权

select t.* from 
(
	SELECT
		"TBDW" ,
		SUM(CASE WHEN "NY" = '2025-01' THEN  CAST("ZFYHTS" AS numeric)  ELSE 0 END) AS "01重复隐患条数",
		SUM(CASE WHEN "NY" = '2025-01' THEN  CAST("YHZTS" AS numeric)  ELSE 0 END) AS "01隐患总条数",
		SUM(CASE WHEN "NY" = '2025-01' THEN  CAST("ZFFSL" AS numeric)  ELSE 0 END) AS "01重复发生率",
		
		SUM(CASE WHEN "NY" = '2025-02' THEN  CAST("ZFYHTS" AS numeric)  ELSE 0 END) AS "02重复隐患条数",
		SUM(CASE WHEN "NY" = '2025-02' THEN  CAST("YHZTS" AS numeric)  ELSE 0 END) AS "02隐患总条数",
		SUM(CASE WHEN "NY" = '2025-02' THEN  CAST("ZFFSL" AS numeric)  ELSE 0 END) AS "02重复发生率",
		
		SUM(CASE WHEN "NY" = '2025-03' THEN  CAST("ZFYHTS" AS numeric)  ELSE 0 END) AS "03重复隐患条数",
		SUM(CASE WHEN "NY" = '2025-03' THEN  CAST("YHZTS" AS numeric)  ELSE 0 END) AS "03隐患总条数",
		SUM(CASE WHEN "NY" = '2025-03' THEN  CAST("ZFFSL" AS numeric)  ELSE 0 END) AS "03重复发生率",
		
		SUM(CAST("ZFYHTS" AS numeric)) AS "1-本月累计重复隐患",
		SUM(CAST("YHZTS" AS numeric)) AS "1-本月累计隐患",
		CAST(SUM(CAST("ZFYHTS" AS numeric))/SUM(CAST("YHZTS" AS numeric)) as DECIMAL(10,2)) AS "1-本月累计"
	FROM "JT_ZFYHSB"  WHERE TO_DATE("NY", 'YYYY-MM-DD') BETWEEN '2025-01-01' AND '2025-04-30'
  GROUP BY "TBDW"
) t