select * from tt where datetime between atarttime and endtime and mod(datetime-starttime,intervaltime)=0
select * from (select * from tablename where dt between starttime and endtime order by dt) where (rownum-1) % intervaltime = 0;
select * from ( select startTime ,endTime ,endTime-startTime min,rownum from t ) where startTime >=date and endTime<=date2 and min=intervaltime 用下内联视图
问题解决,感谢2楼的mod和大家的参与,结贴给分。解决方案(时间间隔部分): select t.* from t where mod((inserttime-to_date('2009-9-3 8:59:58','yyyy-mm-dd hh24:mi:ss'))*24*3600,intervaltime )=0
where datetime between atarttime and endtime
and mod(datetime-starttime,intervaltime)=0
(select * from tablename where dt between starttime and endtime order by dt)
where (rownum-1) % intervaltime = 0;
from (
select startTime ,endTime ,endTime-startTime min,rownum
from t
)
where startTime >=date and endTime<=date2 and min=intervaltime
用下内联视图
select t.* from t where mod((inserttime-to_date('2009-9-3 8:59:58','yyyy-mm-dd hh24:mi:ss'))*24*3600,intervaltime )=0