1、原始数据(这个数据是下面sql 查出的数据)
月份 | 营业部代码 | 用户类型 | 开户奖调整 | 提成调整 | 薪酬支出调整合计 |
---|---|---|---|---|---|
... | ... | ... | ... | ... | ... |
select a.trademonth tradeMonth,
a.broker_branch brokerBranch,
decode(b.user_type, '3', '2', '5', '2', b.user_type) userType,
a.margin_trade_tc_adj tc,
a.open_bal_money_adj openBalMoneyAdj,
a.broker_branch_sum brokerBranchSum
from rzrq.tb_rzrq_cust_martc_cross a
inner join xc.tb_h_snap_user b on a.user_id = b.user_id
and a.trademonth = b.archive_date
and b.user_type in ('0', '1', '3', '4', '5')
where a.cust_bra