oracle查询某一时间点数据变化

描述： oracle查询某一时间节点的数据

select 所查字段,versions_starttime, versions_endtime, versions_operation
from 字段所在表 versions
    between timestamp minvalue and maxvalue
where versions_starttime is not null
and [可以加一些条件筛选出来希望看的那条数据]
order by versions_starttime desc;

举例：

select column_name,versions_starttime, versions_endtime, versions_operation
from table_name versions
    between timestamp minvalue and maxvalue
where versions_starttime is not null
and id = '唯一数据'
order by versions_starttime desc;