sql中如何取出90分钟内的记录

Question

sql中如何取出90分钟内的记录

Answer 1

select * 
from tb
where datediff(minute,times,getdate())between 0 and 90

Answer 2

SELECT * FROM TB WHERE DATEDIFF(MI,TB.DATECOL,GETDATE())

Answer 3

select * from tb where datediff(minute,times,getdate())<90

Answer 4

select * from tb where datediff(mi,coldate,getdate())<=90

Answer 5

日期差值计算
abs(dateadd(day,开始日期，结束日期))<90

Answer 6

select * 
from tb t
where exists(
    select 1
    from tb
    where abs(datediff(mi,times,t.times))<=90)这样？