select aka130,
bkc021,
sum(rc),
sum(bke040),
sum(ake034),
sum(ake029),
sum(bke082),
sum(bke053)
from (select aka130,
decode(bkc021,
'11',
'在职',
'12',
'在职',
'13',
'在职',
'14',
'在职',
'15',
'在职',
'16',
'在职',
'21',
'退休',
'22',
'退休',
'23',
'退休',
'26',
'退休',
'15',
'单建统筹',
'25',
'单建统筹',
'31',
'离休',
'33',
'二乙待遇',
'35',
'退休',
'40',
'在职',
'41',
'退休',
'42',
'在职',
'43',
'退休',
'44',
'在职',
'45',
'退休',
'46',
'退休',
'47',
'退休') bkc021,
nvl(sum(nvl(bka135, 0)), 0) rc,
nvl(sum(nvl(AKE039, 0)), 0) bke040,
nvl(sum(nvl(AKE034, 0)), 0) AKE034,
nvl(sum(nvl(AKE029, 0)), 0) AKE029,
nvl(sum(nvl(ZYXJ, 0)), 0) BKE082,
nvl(sum(nvl(bke053, 0)), 0) bke053
from yc121_yj
where 1 = 1
and akb020 = '1003'
and bkc021 in ('11',
'12',
'13',
'14',
'15',
'16',
'21',
'22',
'23',
'26',
'15',
'25',
'31',
'33',
'35',
'40',
'41',
'42',
'43',
'44',
'45',
'46',
'47')
and aae036 >= to_date('20130102', 'yyyy-mm-dd')
and aae036 < to_date('20130103', 'yyyy-mm-dd')
and akc190 like 'MZ%'
group by aka130, bkc021)
group by aka130, bkc021
--order by aka130, bkc021 desc
bkc021,
sum(rc),
sum(bke040),
sum(ake034),
sum(ake029),
sum(bke082),
sum(bke053)
from (select aka130,
decode(bkc021,
'11',
'在职',
'12',
'在职',
'13',
'在职',
'14',
'在职',
'15',
'在职',
'16',
'在职',
'21',
'退休',
'22',
'退休',
'23',
'退休',
'26',
'退休',
'15',
'单建统筹',
'25',
'单建统筹',
'31',
'离休',
'33',
'二乙待遇',
'35',
'退休',
'40',
'在职',
'41',
'退休',
'42',
'在职',
'43',
'退休',
'44',
'在职',
'45',
'退休',
'46',
'退休',
'47',
'退休') bkc021,
nvl(sum(nvl(bka135, 0)), 0) rc,
nvl(sum(nvl(AKE039, 0)), 0) bke040,
nvl(sum(nvl(AKE034, 0)), 0) AKE034,
nvl(sum(nvl(AKE029, 0)), 0) AKE029,
nvl(sum(nvl(ZYXJ, 0)), 0) BKE082,
nvl(sum(nvl(bke053, 0)), 0) bke053
from yc121_yj
where 1 = 1
and akb020 = '1003'
and bkc021 in ('11',
'12',
'13',
'14',
'15',
'16',
'21',
'22',
'23',
'26',
'15',
'25',
'31',
'33',
'35',
'40',
'41',
'42',
'43',
'44',
'45',
'46',
'47')
and aae036 >= to_date('20130102', 'yyyy-mm-dd')
and aae036 < to_date('20130103', 'yyyy-mm-dd')
and akc190 like 'MZ%'
group by aka130, bkc021)
group by aka130, bkc021
--order by aka130, bkc021 desc
解决方案 »
- SQL “+”是什么用途?
- 评论的表关系设计
- Oracle9i 客戶端無法連接服務器(300分求解)
- 求一数据比对sql
- 大家有谁知道Oracle里竖列变横列的函数是什么呀?着急呀~~~~~~~~~
- shell导出查询结果
- oracle9i中要将table建在哪个空间?才能让一般的用户(user1)以normal的身份查询到?
- 如何将表中的某个字段删除
- 请问日文系统下的软件改在中文下运行可以吗
- select * from table where time=SYS.time ? 对不对? 如何得到当天时间输入的记录?
- oracle 表无法删除
- 查询10000条以上的数据比较慢,如何才能提高查询速度,谢谢
group by需要查询所有的数据,你那这个时间去和不加group by时全部展开的时间去对比一下看看
如果相差不多,那就不是group by 的问题,而是整个sql的问题