bzsjy的博客

delete from tb_charging_log c where c.session_id in ( select b.session_id from ( select trunc(a.start_time, ‘mi’), trunc(a.end_time, ‘mi’), a.bus_job_no, a.station_no, row_number() over(partition by trunc(a.start_time, 'mi'), trunc(a.end_time, 'm