查询出在最近10分钟(或一段时间区间内)插入数据库某个表的所有数据。
SQLSever数据库语法:table为表名,Time插入时间
select * from table where DateDiff(m,Time,GetDate())<10
select * from deal where v_dealdatetime>SYSDATE-1/144
select * from deal where v_dealdatetime>(sysdate+interval '-10' minute)
SQLSever数据库语法:table为表名,Time插入时间
select * from table where DateDiff(m,Time,GetDate())<10
select * from deal where v_dealdatetime>SYSDATE-1/144
select * from deal where v_dealdatetime>(sysdate+interval '-10' minute)