SELECT CORP_NAME,
START_TIME,
END_TIME,
(TO_DATE('2010-6-26 19:12:02', 'yyyy-MM-dd hh24:mi:ss') -
TO_DATE('2010-6-26 15:37:02', 'yyyy-MM-dd hh24:mi:ss')) * 24 as "TIME_INTERVAL",
REMARK
FROM T_B_PHD_RECORD
WHERE START_TIME >= TO_DATE('2010-6-26 15:37:02', 'yyyy-MM-dd hh24:mi:ss')
AND END_TIME <= TO_DATE('2010-6-26 19:12:02', 'yyyy-MM-dd hh24:mi:ss')
AND END_TIME IS NOT NULL;现在我还想在查询中添加一个条件:"TIME_INTERVAL" 就是这一列(比如:间隔时间大于2)的所有记录,麻烦大家帮帮忙哈~
START_TIME,
END_TIME,
(TO_DATE('2010-6-26 19:12:02', 'yyyy-MM-dd hh24:mi:ss') -
TO_DATE('2010-6-26 15:37:02', 'yyyy-MM-dd hh24:mi:ss')) * 24 as "TIME_INTERVAL",
REMARK
FROM T_B_PHD_RECORD
WHERE START_TIME >= TO_DATE('2010-6-26 15:37:02', 'yyyy-MM-dd hh24:mi:ss')
AND END_TIME <= TO_DATE('2010-6-26 19:12:02', 'yyyy-MM-dd hh24:mi:ss')
AND END_TIME IS NOT NULL;现在我还想在查询中添加一个条件:"TIME_INTERVAL" 就是这一列(比如:间隔时间大于2)的所有记录,麻烦大家帮帮忙哈~
select CORP_NAME, START_TIME, END_TIME, TIME_INTERVAL, REMARK from (你的查询) where TIME_INTERVAL > 2
估计你不喜欢