高分求救！求一条SQL查询语句！查一个表最新5分钟的数据怎么写？

[danis]

表的时间字段是dPingTime
我不知道怎么写，

select * from List Where DateDiff(n,dPingTime,getdate()) > 5 这样可以吗？？？？

[kk19840210]

select   *   from   List   Where   DateDiff(ss,dPingTime,getdate())/60<=5

[QQQQAnnie]

create table td(d datetime)

select * from td where datediff(minute,d,getdate())=5

试试

[QQQQAnnie]

应该有<

[zefuzhang2008]

select * from List Where dPingTime>getdate()-5.00000000/24.00000000/60.00000000 
注:可用到索引

[areswang]

select * from List where datediff(minute,dPingTime,getdate())<=5

[dawugui]

select * from List Where DateDiff(mi,dPingTime,getdate()) <= 5

[Kasbaster]

select * from List where datediff(minute,dPingTime,getdate()) <=5