1 . 根据时间显示每分钟的记录数
oracle
select to_char(les_deal_time,'yyyy-MM-dd HH24:mi'),count(*) from ods_cust_order where source_sn like 'LBC82868563%'
and les_deal_flag='7' group by to_char(les_deal_time,'yyyy-MM-dd HH24:mi') order by to_char(les_deal_time,'yyyy-MM-dd HH24:mi')
mysql