很有用的sql分组查询，竖向结果，转为横向表，记录一下备查。

原创已于 2025-12-16 17:24:22 修改 · 601 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#前端 #linux #javascript

收录于

于 2024-08-13 15:38:53 首次发布

SELECT txt15,
(CASE WHEN txt2 = '利辛兴华医院' THEN SUM(CONVERT(txt47, DECIMAL(11,2))) ELSE 0 END) AS '利辛兴华医院' ,
(CASE WHEN txt2 = '利辛县人民医院' THEN SUM(CONVERT(txt47, DECIMAL(11,2))) ELSE 0 END) AS '利辛县人民医院' ,
(CASE WHEN txt2 = '利辛县城关镇东风村卫生室' THEN SUM(CONVERT(txt47, DECIMAL(11,2))) ELSE 0 END) AS '利辛县城关镇东风村卫生室'
 FROM doc_yb_20240804 WHERE txt5='马友宽' AND txt7='脑卒中' AND (LEFT(txt11,10) BETWEEN '2023.01.12' AND '2024.09.12') GROUP BY txt15

统计病历等级数：

SELECT txt7 AS 姓名,
 SUM(CASE WHEN txt12 = '甲级' THEN 1 ELSE 0 END) AS 甲级,
 SUM(CASE WHEN txt12 = '乙级' THEN 1 ELSE 0 END) AS 乙级,
 SUM(CASE WHEN txt12 = '丙级' THEN 1 ELSE 0 END) AS 丙级
 FROM doc_blzk_main_list WHERE k_del='1' AND txt4='肾内科' GROUP BY  txt7