|
发表于 2013-11-8 08:57:41
|
显示全部楼层
本帖最后由 yinlun 于 2013-11-8 09:00 编辑
另外,从sql语句的效率上将,用or效率低,你分成两条语句- SELECT
- SUM(fID.BUILTORG) builtorg
- ,SUM(fID.FIRSTORG) firstorg
- ,SUM(fID.SECONDORG) secondorg
- ,SUM(fID.UNDERORG) underorg
- ,SUM(fID.MANNINGQUOTAS) manningquotas
- ,SUM(fID.FPBRY) fpbry
- ,SUM(fID.FULL_TIME) full_time
- ,SUM(fID.PART_TIME) part_time
- ,SUM(fID.COLLEGEGRADUATE) collegegraduate
- ,SUM(fID.SCHOOLANDBELOW) schoolandbelow
- ,SUM(fID.ADVANCED) advanced
- ,SUM(fID.INTERMEDIATE) intermediate
- ,SUM(fID.PRIMARYANDBELOW) primaryandbelow
- ,SUM(fID.F45SYS) f45sys
- ,SUM(fID.F30Z44S) f30z44s
- ,SUM(fID.F29SYX) f29syx
- ,SUM(fID.ACCOUNTANTS) accountants
- ,SUM(fID.TRAININGS) trainings
- ,SUM(fID.SELFTRAINING) selftraining
- ,SUM(fID.GROUPTRAINING) grouptraining
- ,SUM(fID.UNITTRAINING) unittraining
- FROM
- REP_ORGPERSON fID
- WHERE
- (
- fID.fYEAR = '2013'
- AND fID.fMONTH = '6'
- AND fID.fREPORTTYPE = '统计报表'
- AND fID.fAUDITSTATUS = '审核通过'
- AND fID.FUNITPATH LIKE '/ORG01.ogn%ogn%'
- AND NOT (
- fID.FUNITPATH LIKE '/ORG01.ogn%ogn%ogn%'
- )
- )
- UNION ALL
- SELECT
- SUM(fID.BUILTORG) builtorg
- ,SUM(fID.FIRSTORG) firstorg
- ,SUM(fID.SECONDORG) secondorg
- ,SUM(fID.UNDERORG) underorg
- ,SUM(fID.MANNINGQUOTAS) manningquotas
- ,SUM(fID.FPBRY) fpbry
- ,SUM(fID.FULL_TIME) full_time
- ,SUM(fID.PART_TIME) part_time
- ,SUM(fID.COLLEGEGRADUATE) collegegraduate
- ,SUM(fID.SCHOOLANDBELOW) schoolandbelow
- ,SUM(fID.ADVANCED) advanced
- ,SUM(fID.INTERMEDIATE) intermediate
- ,SUM(fID.PRIMARYANDBELOW) primaryandbelow
- ,SUM(fID.F45SYS) f45sys
- ,SUM(fID.F30Z44S) f30z44s
- ,SUM(fID.F29SYX) f29syx
- ,SUM(fID.ACCOUNTANTS) accountants
- ,SUM(fID.TRAININGS) trainings
- ,SUM(fID.SELFTRAINING) selftraining
- ,SUM(fID.GROUPTRAINING) grouptraining
- ,SUM(fID.UNITTRAINING) unittraining
- FROM REP_ORGPERSON fID(
- fID.fYEAR = '2013'
- AND fID.fMONTH = '6'
- AND fID.fREPORTTYPE = '单位报表'
- AND fID.fAUDITSTATUS = '审核通过'
- AND fID.FUNITPATH LIKE '/ORG01.ogn'
- );
复制代码 |
|