SQL> SELECT
2 DATA_DATE,
3 MGR_CODE,
4 IDX_CODE,
5 IDX_NAME,
6 CUR_NAME,
7 sum(decode(data_date, 20130101, ACCT_BAL, 0)) as ACCT_BAL,
8 sum(decode(data_date, 20130101, D_CMP_BAL, 0)) as D_CMP_BAL,
9 sum(decode(data_date, 20130101, M_CMP_BAL, 0)) as M_CMP_BAL,
10 sum(decode(data_date, 20130101, Q_CMP_BAL, 0)) as Q_CMP_BAL,
11 sum(decode(data_date, 20130101, Y_CMP_BAL, 0)) as Y_CMP_BAL,
12 sum(decode(data_date, 20130101, Y_AVG_BAL, 0)) as Y_AVG_BAL,
13 sum(decode(data_date, 20130101, SIM_PROFIT, 0)) as SIM_PROFIT,
14 UNIT1_CODE,
15 UNIT2_CODE,
16 UNIT3_CODE,
17
SQL运行突然SESSION中断错误
最新推荐文章于 2022-03-01 11:19:32 发布