select * from mini_account_log_pt_75 where account_no='30020000006446750156' and trans_dt between to_date('2010-12-01 00:00:00','YYYY-MM-DD HH24:MI:SS') and to_date('2011-12-31 23:59:50','YYYY-MM-DD HH24:MI:SS')
根据时间范围统计个数
select count(mini_trans_log_id) from mini_account_log_pt_75 where account_no='30020000006446750156' and trans_dt between to_date('2010-12-01 00:00:00','YYYY-MM-DD HH24:MI:SS') and to_date('2011-12-31 23:59:50','YYYY-MM-DD HH24:MI:SS')