" select t3.dw,nvl(t4.adhf,0),nvl(t4.ayhf,0),nvl(t4.azl,0),nvl(t4.cdhf,0),nvl(t4.cyhf,0),nvl(t4.czl,0)"+
" from "+
" (select '便民中心' as dw from dual union select '纪委' as dw from dual union select '督查支队' as dw from dual"+
" union select '国保支队' as dw from dual union select '经侦支队' as dw from dual union select '刑侦支队' as dw from dual "+
" union select '视侦支队' as dw from dual union select '监管支队' as dw from dual union select '法制支队' as dw from dual"+
" union select '治安支队' as dw from dual union select '消防支队' as dw from dual union select '出入境支队' as dw from dual"+
" union select '禁毒支队' as dw from dual union select '网安支队' as dw from dual union select '内保支队' as dw from dual"+
" union select '交管支队' as dw from dual union select '江岸区分局' as dw from dual union select '江汉区分局' as dw from dual"+
" union select '硚口区分局' as dw from dual union select '汉阳区分局' as dw from dual union select '武昌区分局' as dw from dual"+
" union select '青山区分局' as dw from dual union select '洪山区分局' as dw from dual union select '东西湖区分局' as dw from dual"+
" union select '蔡甸区分局' as dw from dual union select '江夏区分局' as dw from dual union select '黄陂区分局' as dw from dual"+
" union select '新洲区分局' as dw from dual union select '水上分局' as dw from dual union select '经济技术开发区分局(汉南区)' as dw from dual"+
" union select '东湖新技术开发区分局' as dw from dual union select '东湖生态旅游风景区分局' as dw from dual union select '化学工业区分局' as dw from dual"+
" union select '轨道交通分局' as dw from dual) t3"+
" left join ("+
" select nvl(t1.dw,t2.dw) as dw,nvl(azl,0) as azl,nvl(t1.adhf,0) as adhf,nvl(t1.ayhf,0) as ayhf,nvl(czl,0) as czl,nvl(t2.cdhf,0) as cdhf,nvl(t2.cyhf,0) as cyhf from"+
" (select nvl(zbcompany,'便民中心') as dw,"+
" count(case when status = '0' then 0 end) as adhf,"+
" count(case when status = '1' then 0 end) as ayhf,"+
" count(*) as azl"+
" from advisory@online_nw where "+advisorytimeSql+
" zbcompany is null group by zbcompany "+
" union all"+
" select nvl(zbcompany,'便民中心') as dw,"+
" count(case when status = '2' then 0 end) as adhf,"+
" count(case when status = '1' then 0 end) as ayhf,"+
" count(*) as azl"+
" from advisory@online_nw where "+advisorytimeSql+
" zbcompany is not null group by zbcompany) t1"+
" full join"+
" (select nvl(zbcompany,'便民中心') as dw,"+
" count(case when status = '0' then 0 end) as cdhf,"+
" count(case when status = '1' then 0 end) as cyhf,"+
" count(*) as czl"+
" from complain@wsjj_smzj where "+timeSql+
" zbcompany is null group by zbcompany "+
" union all"+
" select nvl(zbcompany,'便民中心') as dw,"+
" count(case when status = '2' then 0 end) as cdhf,"+
" count(case when status = '1' then 0 end) as cyhf,"+
" count(*) as czl"+
" from complain@wsjj_smzj where "+timeSql+
" zbcompany is not null group by zbcompany) t2"+
" on t1.dw = t2.dw) t4"+
" on t4.dw = t3.dw order by dw";
求问:这个sql语句有什么错误,放在Oracle Sql Developer上运行错误,求解
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-
0条回答 默认 最新
悬赏问题
- ¥15 visual studio2022中文乱码无法解决
- ¥15 关于华为5g模块mh5000-31接线问题
- ¥15 keil L6007U报错
- ¥15 webapi 发布到iis后无法访问
- ¥15 初学者如何快速上手学习stm32?
- ¥15 如何自动更换布娃娃图片上的衣服
- ¥15 心理学eprime编程
- ¥15 arduino esp8266开发
- ¥15 stm32单片机通过485发送命令给驱动器控制电机转动,同样的代码f103可以控制电机转动,换到f407不能动了,但是用串口助手调试407显示发送的命令都是正确的,卡了好久了这是发送规则
- ¥15 stm32f103c8t6最小系统板+2.8寸TFTLCD板子