- 论坛徽章:
- 0
|
select
substr(C_INTER_CDE,3,4),
case when t1.c_kind_no='03' then '10' else '11' end ,
t1.c_kind_no ,
sum(TA_MAIN8.N_PRM_VAR_YUAN)
FROM RPT_PLYEDR TA_MAIN8 , t_prd_prod t1
WHERE TA_MAIN8.T_INSRNC_BGN_TM BETWEEN '2012-02-26 00:00:00' AND ----起保日期
'2012-02-27 00:00:00'
and t1.c_prod_no=TA_MAIN8.c_prod_no
group by
substr(C_INTER_CDE,3,4),
case when t1.c_kind_no='03' then '10' else '11' end ,
t1.c_kind_no with ur ;
---执行用时间11秒
select
substr(C_INTER_CDE,3,4),
case when t1.c_kind_no='03' then '10' else '11' end ,
t1.c_kind_no ,
sum(TA_MAIN8.N_PRM_VAR_YUAN)
FROM RPT_PLYEDR TA_MAIN8 , t_prd_prod t1
WHERE TA_MAIN8.T_INSRNC_BGN_TM BETWEEN '2012-02-26 00:00:00.00000' AND ----起保日期
'2012-02-27 00:00:00.00000'
and t1.c_prod_no=TA_MAIN8.c_prod_no
group by
substr(C_INTER_CDE,3,4),
case when t1.c_kind_no='03' then '10' else '11' end ,
t1.c_kind_no with ur ;
---执行用时间48秒
select DA_BEG_times,DA_RND_times from ZFX_YMD_TIMES;
DA_BEG_TIMES DA_RND_TIMES
2012-02-26 00:00:00 2012-02-27 00:00:00 ;
---查询这个表的2个时间
select
substr(C_INTER_CDE,3,4),
case when t1.c_kind_no='03' then '10' else '11' end ,
t1.c_kind_no ,
sum(TA_MAIN8.N_PRM_VAR_YUAN)
FROM RPT_PLYEDR TA_MAIN8 , t_prd_prod t1
WHERE TA_MAIN8.T_INSRNC_BGN_TM BETWEEN (select DA_BEG_times from ZFX_YMD_TIMES ) AND ----起保日期
(select DA_RND_times from ZFX_YMD_TIMES )
and t1.c_prod_no=TA_MAIN8.c_prod_no
group by
substr(C_INTER_CDE,3,4),
case when t1.c_kind_no='03' then '10' else '11' end ,
t1.c_kind_no with ur ;
----已经3分钟了 还没出来
---求解决办法呀 大牛们给我出出注意吧,困扰2天了 |
|