日期:2014-05-17 浏览次数:21197 次
SELECT MIN(CASE WHEN to_char(t_time,'YYYY-MM-DD HH24:MI:SS')>'2012-01-10 12:53:40' THEN UPDATE_TIME ELSE NULL END) "MIN_TIME", MAX(CASE WHEN to_char(t_time,'YYYY-MM-DD HH24:MI:SS')<'2012-01-10 12:53:40' THEN UPDATE_TIME ELSE NULL END) "MAX_TIME" FROM table_name