查询出3分钟前这个test表的情况
select * from base_node as of timestamp(systimestamp - interval '3' minute )
where node_desc = '勘验笔录';
参考:
http://www.cnblogs.com/luofuxian/archive/2011/12/07/2279241.html
http://blog.itpub.net/703656/viewspace-812010/
select * from base_node as of timestamp(systimestamp - interval '3' minute )
where node_desc = '勘验笔录';
参考:
http://www.cnblogs.com/luofuxian/archive/2011/12/07/2279241.html
http://blog.itpub.net/703656/viewspace-812010/