mySql写法 select * from om_meeting_schedule s where s.is_use1 ORDER BY ABS(NOW() - s.meeting_begin_date) ASC limit 1 oracle写法 SELECT * FROM ( SELECT *, ABS(NOW() - startTime) AS diffTime FROM om_meeting_schedule ORDER BY diffTime ASC ) C WHERE ro…