中信-提现查询

admin

select  sum (REDUCE_AMOUNT) from  LJ_ZXCT where ACCOUNTID='J00043100001702' and (type=12 or type=09)
AND CREATRTIME< to_date('2023/11/30 23:59:59','YYYY/MM/DD HH24:mi:ss')
and CREATRTIME >= to_date('2023/04/01 00:00:00','YYYY/MM/DD HH24:mi:ss')