数据库学德很差,我现在有一个问题
select d.ORG_NAME, count(b1),count(b2),count(b3),WTZG_BFHXZ
from HSE_JC_WTZG, SY_ORGANIZATION d
where d.ORG_CODE = substr(WTZG_WTSSDW_CODE, 0, 5)
and WTZG_BFHXZ ='01' b1 and WTZG_BFHXZ <> '02' b2 and WTZG_BFHXZ <> '03'b3
group by d.ORG_NAME, WTZG_BFHXZ
union
select d.ORG_NAME,count(b1),count(b2),count(b3),WTZG_BFHXZ
from HSE_JC_WTZG, SY_ORGANIZATION d
where d.ORG_CODE = substr(WTZG_WTSSDW_CODE, 0, 5)
and WTZG_BFHXZ <>'01' b1 and WTZG_BFHXZ ='02' b2 and WTZG_BFHXZ <> '03'b3
group by d.ORG_NAME, WTZG_BFHXZ
union
select d.ORG_NAME,count(b1),count(b2),count(b3), WTZG_BFHXZ
from HSE_JC_WTZG, SY_ORGANIZATION d
where d.ORG_CODE = substr(WTZG_WTSSDW_CODE, 0, 5)
and WTZG_BFHXZ <>'01' b1 and WTZG_BFHXZ <> '02' b2 and WTZG_BFHXZ = '03'b3
group by d.ORG_NAME, WTZG_BFHXZ
各位看下错在哪?(count(b1),count(b2),count(b3)必须得显示)
select d.ORG_NAME, count(b1),count(b2),count(b3),WTZG_BFHXZ
from HSE_JC_WTZG, SY_ORGANIZATION d
where d.ORG_CODE = substr(WTZG_WTSSDW_CODE, 0, 5)
and WTZG_BFHXZ ='01' b1 and WTZG_BFHXZ <> '02' b2 and WTZG_BFHXZ <> '03'b3
group by d.ORG_NAME, WTZG_BFHXZ
union
select d.ORG_NAME,count(b1),count(b2),count(b3),WTZG_BFHXZ
from HSE_JC_WTZG, SY_ORGANIZATION d
where d.ORG_CODE = substr(WTZG_WTSSDW_CODE, 0, 5)
and WTZG_BFHXZ <>'01' b1 and WTZG_BFHXZ ='02' b2 and WTZG_BFHXZ <> '03'b3
group by d.ORG_NAME, WTZG_BFHXZ
union
select d.ORG_NAME,count(b1),count(b2),count(b3), WTZG_BFHXZ
from HSE_JC_WTZG, SY_ORGANIZATION d
where d.ORG_CODE = substr(WTZG_WTSSDW_CODE, 0, 5)
and WTZG_BFHXZ <>'01' b1 and WTZG_BFHXZ <> '02' b2 and WTZG_BFHXZ = '03'b3
group by d.ORG_NAME, WTZG_BFHXZ
各位看下错在哪?(count(b1),count(b2),count(b3)必须得显示)
解决方案 »
- VFP调用ORACLE存储过程返回结果集
- oracle语句筛选,请高人指点简洁写法
- oracle基础
- 简单的存储过程,附代码和图片.
- 不显示删除回复显示所有回复显示星级回复显示得分回复 谢谢那位兄弟啊. 非常感谢你. (二)
- 急,怎样重建控制文件??????????????????????
- 求助:请高手看看这个错误是怎么回事
- 请问nuique 与 primary key 有何异同?以下是我的结论,还有其它吗?
- varchar2 的字段为空在查询的时候应该怎么写条件?
- Is there any limitation of datafile size and tablespace size in Oracle8.0.5
- 如何获取发生异常的SQL语句?
- 紧急求救,在线等……oracle表复制问题
from HSE_JC_WTZG, SY_ORGANIZATION d
where d.ORG_CODE = substr(WTZG_WTSSDW_CODE, 0, 5)
and WTZG_BFHXZ = '01'
and WTZG_BFHXZ <> '02'
and WTZG_BFHXZ <> '03'
group by d.ORG_NAME, WTZG_BFHXZ
union
select d.ORG_NAME, 0, count(decode(WTZG_BFHXZ, '02', 2, 0)), 0, WTZG_BFHXZ
from HSE_JC_WTZG, SY_ORGANIZATION d
where d.ORG_CODE = substr(WTZG_WTSSDW_CODE, 0, 5)
and WTZG_BFHXZ <> '01'
and WTZG_BFHXZ = '02'
and WTZG_BFHXZ <> '03'
group by d.ORG_NAME, WTZG_BFHXZ
union
select d.ORG_NAME, 0, 0, count(decode(WTZG_BFHXZ, '03', 1, 0)), WTZG_BFHXZ
from HSE_JC_WTZG, SY_ORGANIZATION d
where d.ORG_CODE = substr(WTZG_WTSSDW_CODE, 0, 5)
and WTZG_BFHXZ <> '01'
and WTZG_BFHXZ <> '02'
and WTZG_BFHXZ = '03'
group by d.ORG_NAME, WTZG_BFHXZ
还有如果你的各个查询结果不存在重复数据的话 可以使用union all 这样速度快的
--and WTZG_BFHXZ ='01' b1 and WTZG_BFHXZ <> '02' b2 and WTZG_BFHXZ <> '03'b3 条件矛盾
以回复http://topic.csdn.net/u/20101228/11/6f27256e-0325-49fd-bba8-5c0f82facdbb.html