SQL> select a.unit3_code 机构编码,
2 a.unit3_name 机构名称,
3 a.dept1_code 部门编码,
4 a.dept1_name 部门名称,
5 a.mgr_code 客户经理编码,
6 a.mgr_name 客户经理名称,
7 b.base 基数
8 from s_pm_mgr_dept_rela a,
9 (select t2.mgr_code, sum(T1.avg * t2.share_rate / 100) / 10000 base
10 from (select acct_no_pk,
11 (SUM(DECODE(T1.DATA_DATE, '20121217', T1.Y_ADD_AF, 0)) -
12 SUM(DECODE(T1.DATA_DATE, '20120101', T1.Y_ADD_AF, 0)) +
13 SUM(DECODE(T1.DATA_DATE,
14 '20120101',
15 T1.ADJUST_AMT_AF,
16 0))) /
17 PKG_UF_BANK.FN_GETDAYS('20120101', '20121217') AVG
18 from t_pm_acct_dtl_af t1
19 whe
利用no_merge优化
最新推荐文章于 2022-06-24 20:01:10 发布