SELECT count(womid) womnum,count(manid) mannum, t.dishi,t.xianqu,t.jiedao,sum(t.a) as a,sum(t.b) as b,sum(diagnosis11) as diagnosis11,sum(diagnosis12) as diagnosis12,
sum(diagnosis21) as diagnosis21,sum(diagnosis22) as diagnosis22,sum(diagnosis31) as diagnosis31,sum(diagnosis32) as diagnosis32
,sum(diagnosis41) as diagnosis41,sum(diagnosis42) as diagnosis42,sum(diagnosis51) as diagnosis51,sum(diagnosis52) as diagnosis52
,sum(diagnosis61) as diagnosis61,sum(diagnosis62) as diagnosis62,sum(medicine_opinion11) as medicine_opinion11,sum(medicine_opinion12) as medicine_opinion12
,sum(medicine_opinion21) as medicine_opinion21,sum(medicine_opinion22) as medicine_opinion22
,sum(medicine_opinion31) as medicine_opinion31,sum(medicine_opinion32) as medicine_opinion32
,sum(medicine_opinion41) as medicine_opinion41,sum(medicine_opinion42) as medicine_opinion42,
sum(al) as al,sum(bl) as bl
from
(SELECT
getRegionTextByCode(p_wom.xz_region_code,1,4) AS dishi,
getRegio
记一次sql的使用,group by ,count()的用法与需要注意的地方
最新推荐文章于 2023-04-17 11:04:28 发布