select * from geimstatus_history t
where to_date(t.data_time,'YYYY-mm-dd') = to_date(sysdate,'YYYY-mm-dd')
AND t.car_state='11'
order by t.gei_mes desc, t.data_time desc
转载于:https://www.cnblogs.com/xinxin1994/p/6221615.html
select * from geimstatus_history t
where to_date(t.data_time,'YYYY-mm-dd') = to_date(sysdate,'YYYY-mm-dd')
AND t.car_state='11'
order by t.gei_mes desc, t.data_time desc
转载于:https://www.cnblogs.com/xinxin1994/p/6221615.html