81,122
社区成员




sql=select dzm,nvl(hpzl,'Z'),zxdm,count(*) from b_zyxmls where zmlm='WXR'and zxdm in ('11','22') group by nvl(hpzl,'Z'),dzm,zxdm;
sql=select dzm,zxdm,
max(case ZJ when 'Z' then S else 0 end) Z,
max(case ZJ when 'J' then S else 0 end) J
from (select dzm,zxdm,nvl(hpzl,'Z')ZJ,count(*)S from b_zyxmls where zmlm='WXR'and zxdm in ('11','22') group by dzm,zxdm,nvl(hpzl,'Z'))
group by dzm,zxdm;